=average(if(isnumber(c20:c31),c20:c31))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column

or maybe...

=if(count(c2:c31)=0,"No Numbers",average(if(isnumber(c20:c31),c20:c31)))
(still array entered)

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

--

Dave Peterson