Adding and subtraction

  • Thread starter Thread starter Murray
  • Start date Start date
M

Murray

Hi, all i need to do is a value is added to column C adds to the running
totlal and if a value is put in column D it subtracts from the running total.
Any help is appreciated

Thanks
Murray
 
Hi,

Put this anywhere except columns c or d

=SUM(C:C)-SUM(D:D)

or for a shorter range

=SUM(C1:C100)-SUM(D1:D100)

Mike
 
If your running total is on each row, (eg in column F), then you could
put this in F2:

=F1+C2-D2

and copy down.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
Excel Formula or equation 3
Sum and Percentage Question... 2
Add/Subtract columns from tab to tab in same file 3
Excel Having trouble subtracting one cell from another and storing the result. Pls help. 3
multipule calculations in a single column 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Subtracting Text from Number 4

Back
Top