Adding and subtraction

[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

 

[Mike H]

Hi,

Put this anywhere except columns c or d

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

or for a shorter range

=SUM(C1:C100)-SUM(D1100)

Mike

 

[Pete_UK]

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