On Jun 27, 2:24 pm, OfficeManager
wrote:
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.

Ok, do you want to count or add up the grades? Sounds like you want to
add them up.
Try =AVERAGE(M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6)

If the grades are already percentages (80=B, 90=A, etc), you are done.
If not, you'll have to calculate the percent depending on how the
grades are determined. But you didn't give that info.