Trying to get rid of the #DIV/0
=IF(SUM(B38:O38)<0,AVERAGE(IF(B38:O38<0,B38:O38) ),0)
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Matt" wrote in message
...
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)
|