Thursday, July 4, 2013

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!
-----------------------------------------------------------------------------------------------------------------------------------------------