SUM with multiple + and -
=A1+A2-A3-A4
or
=Sum(A1:A2)-Sum(A3:A4)
--
HTH...
Jim Thomlinson
"Marge" wrote:
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.
|