This should be simple but I can't figure it out. I have created a table to
tabulate the number of guests to a party. Some are adults, some are
children, some are teens. Some are invited to only the morning event, some
to both morning and evening. Columns are "age category" (adult, child, teen
are entries), "coming to morning" (yes, no are entries), "coming to evening"
(yes, no are entries). Some have responded, many have not yet. All are text
entries. How do I create formulas to sum the adults attending morning,
adults attending evening and the same for children and teens? I've tried
using the IF, COUNT and COUNTIF functions, but none seem to work for text
data in more than one column. Thanks