In D1 enter

=IF(C1="","",C1)

In D2 enter

=IF(C2="","",C2+D1) copy down as far as you want.


Gord Dibben MS Excel MVP

On Wed, 2 Sep 2009 06:54:02 -0700, jenhunley
wrote:

i am trying to set up a running balance for payroll I have charge in column c
and i want to keep a running total in column d how do i get it to add up and
where do i put the formula?