I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would
work.
Help Help Help;.

try this: =sum(c12:c13) - sum(d14:d17)

"azarat" wrote in message
...
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the
result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS
would
work.
Help Help Help;.

"Tieske" wrote:

try this: =sum(c12:c13) - sum(d14:d17)

"azarat" wrote in message
...
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the
result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS
would
work.
Help Help Help;.
What a star. Your formula works.

Try this:

=C12+C13-SUM(D14:D17)

or this:

=SUM(D14:D17)-C12-C13

(it's not clear what you want to subtract from what).

Hope this helps.

Pete

On Jun 27, 12:29*pm, azarat wrote:
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would
work.
Help Help Help;.

IF? you want to sum c12:c13 and then subtract the sum of d14:d17

=sum(C12:C13)-sum(D14:D17)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"azarat" wrote in message
...
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the
result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS
would
work.
Help Help Help;.