Hi Biff,

That worked GREAT!! :) Thanks

I really appreciate it.

BK
"Biff" wrote:

Hi!

You should make an attempt at correcting the errors then you won't have to
mess around dealing with them!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF(ISNUMBER(C9:C19),C9:C19))

Biff

"bk_412" wrote in message
...
I am looking to get an average from like c9:l9. Those cells are linked to
other worksheet averages. They sometime have #div/0! in it. I am loooking
to
ignore that part and just get the average of numbers in those cells.

Any help would be appreciated

regards,

BK