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

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

Any suggestions?

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

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

"Kristin Drover" <Kristin wrote in message
...
I've tried it with SUM at the beginning, and putting in brackets in
different
places, but it keeps coming up VALUE!

Any suggestions?

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kristin Drover" <Kristin wrote in message
...
| I've tried it with SUM at the beginning, and putting in brackets in different
| places, but it keeps coming up VALUE!
|
| Any suggestions?

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

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)


--
Brevity is the soul of wit.


"Kristin Drover" wrote:

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

Any suggestions?