Sum the value of cells, when cells contain errors

[superted]

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

 

[Bob Phillips]

=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)