Running Balance

J

jenhunley

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

Luke M

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
running balance 2
A running-balance column in a bank-tracking table 7
Formula question -simple for those who know 5
How do I create a running balance? 1
columns as checkbook 6
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
How do I make a negative balance automatically appear in red? 2

Top