Trying to get rid of the #DIV/0
Actually that will still return the error if there are actual zeros in
B38:O38 and no other numbers which I assume it can be given the last part of
the OP's formula
COUNT(B38:O38)-COUNTIF(B38:O38,0)
--
Regards,
Peo Sjoblom
"Tom Hutchins" wrote in message
...
Try
=IF(COUNT(B38:O38)=0,0,SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)))
Hope this helps,
Hutch
"Matt" wrote:
I have this formula in my cell but Can I get rid of the#DIV/0?
The formula in the cell is
=SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)
|