Average

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.
 
J

Jim Thomlinson

Use a formula like this...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top