ExcelBanter - Adding and subtraction

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding and subtraction (https://www.excelbanter.com/excel-worksheet-functions/205367-adding-subtraction.html)

Murray

Adding and subtraction

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

Mike H

Adding and subtraction

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

"Murray" wrote:

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

Pete_UK

Adding and subtraction

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

On Oct 7, 11:27*am, Murray wrote:
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

All times are GMT +1. The time now is 04:29 AM.