Excell formula.

  • Thread starter Thread starter azarat
  • Start date Start date
A

azarat

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:

=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
 
IF? you want to sum c12:c13 and then subtract the sum of d14:d17

=sum(C12:C13)-sum(D14:D17)
 
Back
Top