wedding list help

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to use excel to create what I need for my
weddding invitation list. My fiance wants a count of how
many people from her side of the family are coming vs how
many from mine. I have a sheet where column B is the
number of guests (values such as 2, 4, 3, 8, etc.).
Column C just has a string value of B for bride and G for
groom. I wanted to know how to SUM column B if column C
equals B (for bride).
 
try this to count the number of names from bride where col A contains the
names and col c has b or g
=SUMPRODUCT((a1:a7="b")*(c1:c7<>""))
and this to count the number of people for each
=SUMPRODUCT((b1:b7="b")*C1:C7)
 
Back
Top