Average

[Preschool Mike]

I'm using the AVERAGE formula to return the average of cell X9:BB9 but get
the #DIV/0! error message when the cell are empty. How can I eliminate this
message? I've tried some IF's but don't know all the rules for formulas and
get error message for wrong data type. I've tried
=IF(X9:BB9="","",AVERAGE(X9:BB9)) but this won't work.

 

[Jim Thomlinson]

Use a formula like this...

=IF(and(max(X9:BB9)=0, min(X9:BB9) = 0),"",AVERAGE(X9:BB9)