SUM with multiple + and -

  • Thread starter Thread starter Marge
  • Start date Start date
M

Marge

I know this is so simple but I'm drawing a blank. I'd appreciate any help
you can offer.

In a column I have 3 numbers to add and 2 numbers to subtract.....

65
+40
- 23
- 20

I've tried =SUM(A1:A2)-(A3:A4) but it doesn't work.

Thanks for your help.
 
Hi Marge

If your data in the column is exactly as in your example
SUM function will get you the result of 62
=SUM(A2:A5)

But if your data in the column is as follow :
65
40
23
20
then use =SUM(A2:A5)-SUM(A2:A5) which will give you 62

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
=SUM(A1:A4)
of =a1+a2+a3+a4 if you like to type <grin>
when you add a negative number it get subtracted
Think of 5+1+(-2) , 5+1 = 6, then add the negative of 2 giving 4

Your formula =SUM(A1:A2)-(A3:A4) gives this
First we get 105 - (-43)
Which evaluates to 105 + 43 which give 148
because the negative of a negative value is positive.


Think of + numbers has money in your pocket and - numbers as money you owe
The -(-$10) is money someone owes you!
best wishes
 
Back
Top