=SUM(B69-C69:BS69)
What is wrong with this formula. I continue to get #Value!. I know something
is wrong but can not figure out what.

Do you mean B69-SUM(C69:BS69) ?
or did you intend your =SUM(B69-C69:BS69) to be an array formula, in which
case you need to enter it with Control Shift Enter?

To get the #VALUE! result you've presumably got text (rather than a number)
in at least one of the cells in the range.
--
David Biddulph

"BACH" wrote in message
...
=SUM(B69-C69:BS69)
What is wrong with this formula. I continue to get #Value!. I know
something
is wrong but can not figure out what.

I would write it:
=b69-sum(c69:bs69)

And make sure you don't have any errors in those ranges.

BACH wrote:

=SUM(B69-C69:BS69)
What is wrong with this formula. I continue to get #Value!. I know something
is wrong but can not figure out what.

--

Dave Peterson

=B69-SUM(C69:BS69)
--
Gary''s Student - gsnu200808