formula : =(column A)+(column B)-(column C). Why won't it work?

K

Kristin Drover

I've tried it with SUM at the beginning, and putting in brackets in different
places, but it keeps coming up VALUE!

Any suggestions?
 
P

Paul B

Kristin, try this, =SUM(A:A,B:B)-C:C
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
N

Niek Otten

Please post your exact formula, the values, the result you expected and what you got instead.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've tried it with SUM at the beginning, and putting in brackets in different
| places, but it keeps coming up VALUE!
|
| Any suggestions?
 
D

Dave F

What are you trying to do?

(column A) etc is not correct Excel syntax.

If you're trying to sum/subtract ranges in these columns it would have to
look like this: =SUM(A1:A10)+SUM(B1:B10)-SUM(C1:C10)
 
Top