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   Jul 04, 2013
user Jonathan Nazareno (!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        
Bride side          3