Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Balance | Excel Discussion (Misc queries) | |||
running balance | New Users to Excel | |||
to keep a running balance | Excel Discussion (Misc queries) | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
How do i set up a running balance on one row? | Excel Worksheet Functions |