Hello,
I'm wondering which is the best formula to count the attendance of meetings.
formula.png
I attached a screenshot for reference.
Basically I have been trying to calculate the % of attendance to meetings. When I use the COUNTIF formula, it counts the active members. However, if a member becomes inactive at a certain date, it will trick all the previous meetings stats and the ones he attended.
How can I calculate the % of attendance of members who were active when the meeting occurred? I don't want the formula to count members who were inactive at that time or not yet active members.
Many thanks for your help!
Bookmarks