Re: summing cells that have VALUE errors in them
- From: "T. Valko" <biffinpitt@xxxxxxxxxxx>
- Date: Thu, 22 Feb 2007 17:56:22 -0500
Try this:
=SUMIF(A1:A10,"<>#VALUE!")
Biff
"NewKid" <NewKid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC76A7A0-DBE7-4826-B276-9CCAD6DD302E@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Wildcard character in an "If" statement?
- Next by Date: Re: Auto range of numbers detection
- Previous by thread: Re: Wildcard character in an "If" statement?
- Next by thread: Re: summing cells that have VALUE errors in them
- Index(es):
