getting rid of a #Div/0! error

  • Thread starter Thread starter StephenAccountant
  • Start date Start date
S

StephenAccountant

here is my formula - it is an array formula.

=AVERAGE(IF(D9:G9<>0,D9:G9))

if the cells all show up as blank or nil - i get a #Div/0! error - how can I
stop that from happening?
 
=iF(COUNT(D9:G9)>0,AVERAGE(IF(D9:G9<>0,D9:G9)),"")
too late for me to test it!
best wishes
 
here is my formula - it is an array formula.

=AVERAGE(IF(D9:G9<>0,D9:G9))

if the cells all show up as blank or nil - i get a #Div/0! error - how can I
stop that from happening?
Click to expand...

how about putting the IF statement outside the average statement? it
worked for me, but it returned 0 when even one of the cells in that
range were 0. is that what you want? if it is, then it worked for
me! don't know why it didn't work for you.
 
Back
Top