Which formula can be use for event attendance list?

Hi guys I need help to allocate the table seating accurately.

Lets say I have a name list and number of people will be attending and table allocate to them as follows:

Name Pax Table No
Amber 2 2
Bobby 5 1
Chris 1 2
Derrick 3 3



If I wanna look up for table 2, what formula can be used even if I change the number of people and table number? For example, now I know table 2 has 3 pax, if I change Chris from 1 to 2 pax, how would the table 2 can be affected and change to 4 pax?

Originally Posted by benishiryo

welcome to the forum. assuming F2 has the Table number, maybe:
=SUMIF(C:C,F2,B:B)

but in future, do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

hopefully, i did a correct guess. otherwise, i have wasted time coming up with something that does not help you. if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

Hi, this formula is exactly what I want. thanks a lot