Assuming that M1:P2 contains student test scores, and M3:P3 contains the
total score for each test, try...

Q1, copied down:

=AVERAGE(IF(M1:P10,M1:P1/$M$3:$P$3))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Format cell as
'Percentage'.

Hope this helps!

In article ,
"Scafidel" wrote:

I have a sheet with (L to R) student name, number right each test, total
right, average percentage, letter grade. After the names the row has
question number at bottom which are added up at the end of the row. Total
right are divided by total questions. The problem arises when a student does
not take a test. The blank cell is, in effect, like a zero on a test, as
that student's total is still divided by total questions, giving the wrong
grade (see Fred, who missed the second test). Sorry for the long length.
John 10 9 12 31 97% A
Fred 10 10 20 63% F
Total10 10 12 32 100%