So i have my summer school attendance sheet that i need to calculate the % of students who have shown up for each program but i want the formula to update daily as i input the attendance. The problem i am running into is that the formula is counting the cells with a formula in them but with no number as a non blank.
This is the formula that i have been using =(SUM(C3:V3))/(B3*COUNTA(C3:V3))
I have attached a sheet with my data on one tab and my desired results on the other.
Any help would be greatly appreciated.
Los
Bookmarks