summing cells that have VALUE errors in them

[NewKid]

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.

 

[T. Valko]

Try this:

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

Biff

 

[NewKid]

Thanks much!

Try this:

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

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks much!