D
dbconn
I have the following formula entered to compute the average of a range of
cells and discount zeros. Until I change one of the zeros to a number, I get
#DIV/0!, How do I get rid of this
My formula is: =AVERAGE(Q8:Q18,"<>0",Q8:Q18)
cells and discount zeros. Until I change one of the zeros to a number, I get
#DIV/0!, How do I get rid of this
My formula is: =AVERAGE(Q8:Q18,"<>0",Q8:Q18)