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.

On Jun 27, 2:24 pm, OfficeManager
<OfficeMana...@discussions.microsoft.com> 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.

Thank you, this is very helpful. This works great if the student has taken
any of the test. However, some of my students do not have grades in any of
the columns. How can I show nothing in the cell if the formula brings back a
#DIV/0 because there are no grades in any of the cells?

"Spiky" wrote:

> On Jun 27, 2:24 pm, OfficeManager
> <OfficeMana...@discussions.microsoft.com> 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.
>