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