Average

  • Thread starter Thread starter Preschool Mike
  • Start date Start date
P

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.
 
Use a formula like this...

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