How do I get rid of the #DIV/O in a cell?
I put in the formula:
(SUM(A1:A6)/(COUNT(A1:A6)-COUNTIF(A1:A6,0)))
Some of the worksheets that I put this formula are going to have zero's at
times, so how do I change the formula to not have anything in the cell at all
instead of #DIV/0?
Thanks for your help!
|