Averaging Cells without an Error

[Kcope8302]

I have a worksheet with afew thousands entries. I want to average each column
but I am having a problem since some of the cells have errors. I want to
ignore those errors since they are part of the data and still average the
data in the column. The formula I used is:
=AVERAGE(IF(NOT(ISERROR(D216)),D216)). But i only get 0.

 

[Gary''s Student]

=AVERAGE(IF(ISNUMBER(D216),D216,""))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.

 

[Jarek Kujawa]

=AVERAGE(IF(NOT(ISERROR(D216)),D216,))

insert with CTRL+SHIFT+ENTER not just ENTER

maybe this is yr problem

 

[Jarek Kujawa]

sorry, my formula gives incorrect result

 

[Bob Phillips]

Make sure that you array enter it, that is Ctrl-Shift-Enter, not just Enter.

 

[David Biddulph]

If you are trying to reply to some previous mesage, please remember to quote
enough of that message to put your reply into context. All your recent
posts have been devoid of context, and thus meaningless to most readers of
the newsgroup.

Advice on how to quote is available in numerous places, such as:
http://www.anta.net/misc/nnq/nquote.shtml

 

[Jarek Kujawa]

ok
however sb. understood them I presume...

If you are trying to reply to some previous mesage, please remember to quote
enough of that message to put your reply into context.  All your recent
posts have been devoid of context, and thus meaningless to most readers of
the newsgroup.

Advice on how to quote is available in numerous places, such as:http://www.anta.net/misc/nnq/nquote.shtml
--
David Biddulph






- Poka¿ cytowany tekst -