Formula Question

B

BACH

=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.
 
D

David Biddulph

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.
 
D

Dave Peterson

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

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