How about this..........

=SUMIF(C20:C31,"0")/COUNTIF(C20:C31,"0")

Vaya con Dios,
Chuck, CABGx3



"fivermsg" wrote:


That didn't work.. lets explain it this way, I want the average from
c20:c31 excluding #DIV/0! .

This is what i see,
ex: 100,200,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

The answer i am getting currently is #DIV/0! . the answer i want is
150.


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521051