Count row by row based on a criteria

[firefoxy]

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

[oldchippy]

Hi,

First of all congratulations for your wedding day!

Here's your first wedding present - hope this helps

[firefoxy]

Oldchippy,

Thank you very much for the wedding present. That was excatly what I was looking for! You have no idea how happy I was to see your post just now.

You have made the task of table arrangements that much easier, and my life that my happier.

Thanks.

Firefoxy