I need to make a summary sheet for a list that will count the number of guests sitting at each table. I dont know how to format the text to make it readable so this is the best i can get the forum to let me do it
ex:
Guest Names Table Number
Mr. and Mrs. K. Table 13 2
Ms. Brown Table 11 2
Ms.HeatherBond Table 07 1
Mr. and Mrs. Rob Table 11 2
it's very simple with sumif command
if your data is in cella a2:d10 for example (tables in col c and count in col d)
put a table # somewhere (z1 in this example)
=sumif(c2:c2,z1,d2:d10)
to get the total for that table
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks