So, as you guys know, Stallion and I invited 241 people to our wedding. (I’m dying. SO. MANY. PEOPLE.) But how many of them will actually show up?

There are a couple different rules of thumb you can follow to estimate your wedding attendance:

  • You can assume 100% of your guests will show. Obviously, this is unrealistic, but it gives you a nice cushion in your budget, which is always a good thing. We did this when looking for venues—better to have room to move around than to have everyone squished in like sardines, you know?
  • You can follow the 80% rule. I’ve seen this statistic thrown around in pretty much every wedding planning resource on Earth, so it probably holds some water. According to this method, Stallion and I will have 192 guests attend the wedding.
  • Destination wedding? Word on the street is that you can assume a 65% attendance rate. While Cape May isn’t what comes to mind when most people think of a destination wedding, it may as well be for our guests—the closest guests still have to travel two hours to get there. According to this method, we’ll have 157 guests make the trip.
  • Got a mix of local and out-of-town guests? Combine the above attendance rates by taking 80% of your local guests and 65% of the out-of-towners. We don’t have any local guests, so this method doesn’t apply to us.
  • Review each individual guest, assign them a statistical probability of attendance, and use the weighted head count to estimate your total attendance. Obviously, we took this route. Anything involving fun with Excel is a must-do in my book.

In the interest of full disclosure, I did not come up with this method myself. Actually, I thought I learned about it from another Bee blogger, but I can’t find anything in the archives. I first read about it back when Stallion and I got engaged, a year and a half ago, and I promptly filed it away in my brain without bothering to note where I found it. But wherever it came from, I’m sharing it with you all now, because I think it’s a pretty handy way to estimate your head count.

Anyway. Like I said, review each individual guest on your list. Are they probably attending, maybe attending, or probably not attending? We dropped each guest into one of these buckets, and then we assigned each bucket a statistical probability. The “probably attendings” were weighted at 90%, the “maybe attendings” were weighted at 50%, and the “probably not attendings” were weighted at 10%. Add up the weighted head count, and you have your estimate!

Here it is in action (personal photo):


  • Columns A through C are pretty self-explanatory.
  • Column D has the percentages that correspond with our probability buckets. Leslie and Ben are probably attending, Mona-Lisa is probably not attending, and Ron could go either way.
  • Column E was populated by multiplying the guest count in column C by the probability in column D. Not an Excel wizard? The formula is simple: =C5*D5 (assuming you’re calculating for Leslie and Ben in row 5). Once you’ve calculated it in one cell, click the lower right hand corner of the cell and drag it down to populate the column for the rest of your guests.
  • Cell B1, the total number of invited guests, is the sum of column C, using the formula =SUM(C:C)
  • Cell B2, the estimated number of guests attending, is the sum of column E, using the formula =SUM(E:E)
  • Cell B3 estimates the percentage of guests attending, using the formula =(B2/B1)*100

In conclusion, of the 15 guests I invited from Pawnee, I’m likely to have 9.5 attend, giving me a 63% attendance rate. Gee, I wonder who the half person will be.

This method is good if you know your guest list well—your best friend from college, for example, is way more likely to attend than a distant cousin you haven’t seen in 15 years. And if you’re not sure about a particular guest, that’s what the maybe/50% bucket is for.

Under this method, Stallion and I have an estimated head count of 160, giving us an attendance rate of 66%, which is right in line with the standard 65% estimate for a destination wedding. (In other words, our detailed analysis of the guest list was more or less pointless.) Since RSVPs are still coming in, I can’t say for sure where we’ll shake out numbers-wise, but so far, things are pretty much in line with our estimates. Not that that’s saying much, considering the RSVP deadline is still a month away.

How did you estimate your wedding attendance? How close was your estimate to the actual attendance rate?


Mrs. Filly

Boston, MA
Wedding Date:
April 2014
Hey, Show Me Your Box: Asking My Ladies
Picture Perfect: First Dance
Add a comment


  1. Member
    luluvohn 1194 posts, Bumble bee @ 6:45 am

    Okay, so I just ran your formula for my people and, probably because I just put down 50% for anybody who wasn’t in the bridal party or living in another continent it told me that of my 199 invitees, 105 will accept, at a rate of 52.76%. I’m terrible at predicting other people’s choices, though, so pretty much FI’s entire family got 50% because I’ve only met them twice.

  2. bracelet Bee
    Mrs. Bracelet 279 posts, Helper bee @ 8:14 am

    Ah… love this! I’ve never seen someone take guest-imating to such a mathematical level.

  3. msllama Bee
    Mrs. Llama 22 posts, Newbee @ 6:17 pm

    I did something very similar! I categorized each person as a definitely (x 1), probably (x .8), maybe (x .5), probably not (x .2) and no (x 0). So far…well, right now, let’s just say we must either really be loved, or people really love Disney, because our attendance is at about 90%…yikes! I’m sure it will go down as we get closer….right….RIGHT???

  4. Member
    kellis 54 posts, Worker bee @ 4:48 pm

    LOVE the pawnee example! HAHAHA!!

  5. Member
    Freeze Pops 82 posts, Worker bee @ 2:12 pm

    I’m in awe of your method, Filly! I can’t believe you think spreadsheets are fun, because I LOATHE them. We just went with the 80% guideline. We’ll see how it shakes out, but I’m sure your estimate will be WAY closer than mine.

  6. Member
    Blueskiesinjune 11 posts, Newbee @ 8:43 pm

    Love the Parks and Rec reference 🙂

  7. Member
    renita.brown1 4 posts, Wannabee @ 8:19 pm

    Curious as to how this worked out for you! Happy marriage, btw! 🙂

  8. Guest Icon Guest
    Rachel, Guest @ 1:25 pm

    Please tell me Ben & Leslie showed up! 🙂

    So happy to find this! I am stressing over the guest list!

  9. Member
    NYE2014 472 posts, Helper bee @ 6:46 am

    So I did this last night… just b/c I love excel/formulas and I thought I could pretty accurately dump each of my guests into one of those buckets. It was super interesting b/c like you, I did all that math and the answer shook out to actually follow the wedding planning 20% no’s rule of thumb — which incidentally makes me very happy b/c I’d much rather have 157 guests than 197!

add a comment

Sent weekly. You may unsubscribe at any time.

Find Amazing Vendors