The Guest List: RSVPs, Plus-Ones & the Catering Headcount
This lesson is part of the course
In this lesson
You count confirmed adults, children and plus-ones with COUNTIFS and turn the open replies into a realistic headcount for the caterer.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Splitting the Wedding Budget: Shares, Remaining Amounts & Over-Budget Flags Locked
- The Guest List: RSVPs, Plus-Ones & the Catering Headcount Locked
- Cost per Guest: Tiered Catering Prices with XLOOKUP and Bar Package vs Consumption Locked
- Choosing Vendors: a Weighted Scoring Matrix with SUMPRODUCT and RANK.EQ Locked
- The Payment Schedule: Deposits, Due Dates with WORKDAY & EDATE, and What Is Still Open Locked
- Seating: Tables Needed with ROUNDUP, Guests per Table & Empty Seats Locked
- The Savings Plan: Months to Go with DATEDIF and the Monthly Amount with PMT Locked
- The Wedding Dashboard: Spend vs Budget, RSVP Progress & Open Payments Locked