View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marge Marge is offline
external usenet poster
 
Posts: 33
Default SUM with multiple + and -

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.