Seating Chart

# in party 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 60 GUESTS

TABLE

Name

Last Name

Guest & Kids

KEY

Table 1 Table 2 Table 3 Table 4 Table 5 Table 6 Table 7 Table 8 Table 9 Table 10 Table 11 Table 12 Table 13 Table 14 Table 15 Table 16 Table 17 Table 18 Table 19 Table 20 Table 21 Table 22

Wedding Party Bride's Family Groom's Family

TOTAL GUESTS

KEY

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0

1 Enter in Guests names & their guest and/or kids 2 Type in column "# of guest" the total number attending for that party 3 Assign a table for each guest (& their family) View results in "key" Total guests in column A should equal total guest in column J when you are all done This is the formula for adding up # of people at a specific table number: =SUMIF($B$2:$B$31,4,$A$2:$A$31) If you need to add tables, change the "4" to the correct table number Also, to extend the guest list names, adjust "$B$31" and "$A$31" to whatever line number it ends at