i have a spreadsheet that keeps track of attendance, assignments and grades
of a class. Each week has three columns associated with it. The rows
correspond to the names of the students. So, for the student in row 6, I
would have grades in columns M, P, S, V. Y, AB, AE, AH and AK. The heading
of the column is "Grade". How can I write a formula that will count each
cell in a row that has a grade and divide it by the number of grades in the
row and give me the grade percent? Not all students have grades in each
week, but I would like to have a grade percentage available any week the
teacher looks at the spreadsheet.