Hello All,
For my wedding, I have a list of names, the number of guests coming and the table number that they will be sitting at.
Basically, what I would like to do, is summerize by Table #, how many guests are sitting at each table.
I guess I am looking for a formula, that would go row by row, and if the table # = 1, then count the # of people sitting at that table, and return a total at the end of all the rows that need to be counted.
Name # of guest at the table Table #
Guest A 3 1
Guest B 5 8
Guest C 2 3
Guest D 4 1
and so on...
Summary
Table 1 = 7 Guests
Table 2 = 0 Guests
Table 3 = 2 Guests
Table 8 = 5 Guests
Table 8 = 5 Guests
Hopefully, I have been clear enough...
Thanks guys!
-FireFoxy
Bookmarks