wedding list help

[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).

 

[Don Guillett]

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)

 

[Dana DeLouis]

Congratulations. Just a note. Office has a lot of templates related to
"Weddings."
You may want to check it out. Watch for line wrap on this link.

http://office.microsoft.com/templat...ID=CT010872401033&CTT=4&Origin=CT063452421033

If the link doesn't work, go to Office Templates, "Occasions and Events",
then Weddings.
:>)