Wedding Guest Invite Number Formula

unsolved

Hello everyone,

We are wedding planning and I'm trying to find a formula that will give me a sum of the guests for "Definite" inviting + # in Party and another for "Maybe" inviting + # in Party, so we can have a headcount of the "Definite" invite list. The top # for invite guest includes all the numbers in the "# in Party" column (includes the maybes).

I've tried the =COUNTIF(column, "definite") but it only gives me number of definite which doesn't include the # in party.

Posted Jun 30, 2025, 3:14 AM UTC · locked

14
Loading comments…