Calculate the % of attendance to meetings

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!