Trying to get rid of the #DIV/0
IMO... Bad idea... See my post above. IfError is way to "catch all" and as
such is inherantly dangerous. Check only for the specific error that you
reasonably anticipate. Let any other error flow through.
--
HTH...
Jim Thomlinson
"Dana DeLouis" wrote:
... Can I get rid of the#DIV/0?
=IF(COUNT(B38:O38)=0,0,SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)))
Hi. Excel 2007...
=IFERROR(AVERAGEIF(A1:A5,"<0"),0)
--
Dana DeLouis
"Matt" wrote in message ...
wORKED GREAT tHANKS
"Tom Hutchins" wrote:
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)
|