Sum the value of cells, when cells contain errors
 

Hello,

I am trying to work out, is there an equivalent SUM or SUMIF function to
COUNTA? I am basically trying to find the sum of the values in a couple of
cells - the problem is a couple of the cells do not have numerical values
(i.e. They show up as "#value").

Now the COUNTA function basically ignores those cells when counting the
cells? Is there an equivalent SUM function or SUMIF function that will skip
the cells that contain irregular values?

thanks

Sum the value of cells, when cells contain errors
 

=SUM(IF(ISNUMBER(C1:C8),C1:C8))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"superted" <NOSPAM@spamenterprises wrote in message
news:C2E7CB23.417D%NOSPAM@spamenterprises...
Hello,

I am trying to work out, is there an equivalent SUM or SUMIF function to
COUNTA? I am basically trying to find the sum of the values in a couple of
cells - the problem is a couple of the cells do not have numerical values
(i.e. They show up as "#value").

Now the COUNTA function basically ignores those cells when counting the
cells? Is there an equivalent SUM function or SUMIF function that will
skip
the cells that contain irregular values?

thanks