=SUMIF( YOUR_RANGE, "<#VALUE!" )
--
Regards,
Luc.

"Festina Lente"


"superted" wrote:

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