SUM function that ignores "#VALUE" and error entries??
 

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 function that ignores "#VALUE" and error entries??
 

=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

SUM function that ignores "#VALUE" and error entries??
 

See response in .programming.

--
---
HTH

Bob

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



"superted" <NOSPAM@spamenterprises wrote in message
news:C2E7CB98.43D7%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