How do i get an average with #div/0! in a cell

[Guest]

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

 

[Biff]

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

 

[Guest]

=AVERAGE(IF(ISERROR(A1:A100),"",A1:A100))

ctrl+shift+enter (not just enter)

 

[Biff]

That will fail if there are empty cells in the range.

Biff

 

[Guest]

Hi Biff,

That worked GREAT!! Thanks

I really appreciate it.

BK

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Hi Biff,

That worked GREAT!! Thanks

I really appreciate it.

BK

 

[Guest]

Agree with you biff, that is nice to get a feed back from people that you help.
Happends to ofen that you dont get a feedback.

Best regards

Pb

Biff skrev:

 

[Biff]

I like to know if what I suggested did or did not work.

Biff