How to track meeting attendance without double counting

Before you start

This guide is for attendance totals per meeting: how many people came and how the average changes. To find out who missed a session, track a person’s history or calculate membership fees, you need a separate individual register.

Choose a counting time and an owner. If there are two entrances, assign separate areas so two people do not count the same attendees.

1. Choose categories that do not overlap

The linked spreadsheet adds adults + kids + visitors. To use those three columns, agree on this convention: regular adults, regular children and visitors of any age. Do not also count a visitor under adults or kids.

For example, 42 regular adults, 12 regular children and 6 visitors make 60 attendees. If one visitor is a child, that child is already included in the 6; do not add them to the 12.

2. Record one row per meeting

Record the date, meeting type and three counts. For two meetings on the same date, use two rows and distinguish the time or location in Notes. Do not add a daily total as another meeting row: that would duplicate the attendance.

A cancelled meeting should not have a row that looks like a held meeting. A missing count needs confirmation; do not replace it with zero. Zero means the meeting took place and nobody attended.

3. Calculate the average for the period

This fictional example has four meetings of the same type, all with complete counts. Divide total attendance by the number of held and recorded meetings.

60 + 66 + 58 + 72 = 256 attendances
256 ÷ 4 = 64 attendees per meeting

The 256 attendances do not mean 256 different people. Someone who came four times contributes four attendances. Aggregate counts cannot tell you how many unique people attended.

To compare months, use the same meeting type and counting convention. Do not take an unweighted average of monthly averages: divide combined attendance by the combined number of meetings.

4. Review before sharing

Check that each meeting appears once, all counts are complete, and the year and meeting filter are correct. An unusual number is a reason to check the original record, not to adjust it from memory.

If some meetings are still missing, label the summary as partial. Before interpreting a drop as declining interest, check for schedule changes, closures or special events.