summing cells that have VALUE errors in them
 

I need some assistance in doing a SUM function. The cells I am trying to SUM
may have an #VALUE error in them. How do I get the SUM to not include those
cells?

Thanks.

summing cells that have VALUE errors in them
 

Try this:

=SUMIF(A1:A10,"<#VALUE!")

Biff

"NewKid" wrote in message
...
I need some assistance in doing a SUM function. The cells I am trying to
SUM
may have an #VALUE error in them. How do I get the SUM to not include
those
cells?

Thanks.

summing cells that have VALUE errors in them
 

Thanks much!

"T. Valko" wrote:

Try this:

=SUMIF(A1:A10,"<#VALUE!")

Biff

"NewKid" wrote in message
...
I need some assistance in doing a SUM function. The cells I am trying to
SUM
may have an #VALUE error in them. How do I get the SUM to not include
those
cells?

Thanks.

summing cells that have VALUE errors in them
 

You're welcome. Thanks for the feedback!

Biff

"NewKid" wrote in message
...
Thanks much!

"T. Valko" wrote:

Try this:

=SUMIF(A1:A10,"<#VALUE!")

Biff

"NewKid" wrote in message
...
I need some assistance in doing a SUM function. The cells I am trying
to
SUM
may have an #VALUE error in them. How do I get the SUM to not include
those
cells?

Thanks.