getting rid of a #Div/0! error

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?
 
B

Bernard Liengme

=iF(COUNT(D9:G9)>0,AVERAGE(IF(D9:G9<>0,D9:G9)),"")
too late for me to test it!
best wishes
 
D

dksaluki

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