calculate % of average attendance
I need to calculate % of average attendance across multiple people and events.
for example, I'm either calculating or linking from another sheet the number for the formula and have
Column 1: 49 (the # of people - might change - this is a dynamic # from another sheet)
Column 2: 8 (the # of events that already happened - will change when new events are scheduled. Dynamic # from a formula from another sheet)
Row 1: Total check ins: 78 (dynamic # calculated across all the events)
Row 2: Attendance In-Person: 37 (dynamic # calculated across all the events)
Row 3: Attendance on Zoom: 33 (dynamic # calculated across all the events)
How can i calculate a percentage of the total # of people for each row across all events?
Help Article Resources
Check out the Formula Handbook template!