... 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)