Attendance sheet help

[kensho]

I am stuck trying to track attendance for Practice and Games for my girls softball team. I would like to track the current % based on where we are in the season. We start with 6 practices and then go into a 12 game season.

 

[PawPawGary]

Here’s one way to accomplish what you want.
First determine how many practices/games have been played. In a cell E15 enter this formula =IF(COUNTA(E3:E13)=0,FALSE,TRUE) then copy across to V15. In A15 enter this formula =COUNTIF(E15:J15,TRUE) this will give you the number of practices. In B15 enter =COUNTIF(K15:V15,TRUE) this will give you the number of games. In A3 enter this formula =SUM(COUNTA(E3:J3)/$A$15) format as a percentage and copy down. In B3 enter =SUM(COUNTA(K3:V3)/$B$15) format as a percentage and copy down.
Hope this helps!
Gary

 

[kensho]

Nice! thanks