Excel averaging wihtout #DIV/0

[Amy]

I am doing a spreadsheet and am having trouble with the
final average of student grades. I am having no problem
averaging block grades, but when I try to use the function
to average final grades I get a #DIV/0 error. The problem
is that I need the grades to average progressively. So if
there is no grade recorded as of yet, ( the student hasn't
made it to that part os the course) then the blank is
averaged as if it were a zero. Can anyone help me out on
how to get around my zero problem?

 

[Bob Phillips]

AMy,

Try something like

=IF(ISERROR(AVERAGE(A2:E2)),0,AVERAGE(A2:E2))

 

[Phobos]

=If(iserror(YourFormulaHere),0,YourFormulaHere)

P