yogi_Compute Numbers Attending From The Bride Side And The Groom Side (by Group)

                                          Google Spreadsheet   Post  #1274
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 04, 2013
user Jonathan Nazareno (http://productforums.google.com/forum/?zx=j2xg0kd6omac#!category-topic/docs/spreadsheets/XTu7DTVnVGQ)
SUMif with multiple conditions

I'm trying to count guest based on different criteria.

 

I want B7 (groom side attending) to sum the numbers listed in D2:D6 (#) based on B2:B6="Groom" and C2:C6="yes". Correspondingly to B8 (bride side attending) as well.

 

Group                Side                 Attending                                #

 

1                        Bride                  Yes                                     2

 

2                        Groom                No                                      3

 

3                        Bride                   No                                     2

 

4                        Bride                   Yes                                     1

 

5                        Groom                 Yes                                     4

 

Groom side        4        

attending=   

 

Bride side          3

attending=  

 

Thanks!

-----------------------------------------------------------------------------------------------------------------------------------------------