I have created a basic attendance sheet for our football team for the new year. We normally run training sessions on a Wednesday and a Sunday. If a player attends, they get a green check, if they don't it's a red cross. So that's pretty simple to count up with ''countif''
What i'm trying to do is create a formula that will count the last 10 sessions we have run. "=COUNTIF(A1:A10,"✔️")" The problem with that formula is that not only would the range have to update every session "A2:A11" but there are some Wednesday's and Sundays when we don't run a session and i need this to be skipped.
I thought about created a referance "attendee'' that would have perfect attandance and the range could be worked from that. So it would count 10 "✔️" maybe output the range to another cell and the other formula picked up from there.
A bit stuck. Any ideas would be much appreciated
Bookmarks