Averaging Cells without an Error

  • Thread starter Thread starter Kcope8302
  • Start date Start date
K

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(D2:D16)),D2:D16)). But i only get 0.
 
=AVERAGE(IF(ISNUMBER(D2:D16),D2:D16,""))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
 
=AVERAGE(IF(NOT(ISERROR(D2:D16)),D2:D16,))

insert with CTRL+SHIFT+ENTER not just ENTER

maybe this is yr problem
 
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
 
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 -
Click to expand...
 
Back
Top