Running Balance
 

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?

Running Balance
 

Take a look at the SUM function in help file. Assuming your data is in column F
=SUM(F:F)

If you're doing credits in F, debits in G, your formula would be:
=SUM(F:F)-SUM(G:G)

you can put these formula anywhere EXCEPT for within column(s) F or G since
that would create a circular reference.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?

Running Balance
 

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?