Home |
Search |
Today's Posts |
#1
|
|||
|
|||
running total
I have a Expense/Receipt workbook with 12 sheets title from left to right
July - June. I have one cell for Profit/Loss for each month. I need to have this carried through the entire 12 sheets as a running total. I have had some answers from other groups but either I am too thick or they assume I am really good at this, so I don't understand their answers. Those that looked easy didn't work. I am about intermediate with excel so could anyone please help . Splinter |
#2
|
|||
|
|||
"D.J.Shaw" wrote in message
... I have a Expense/Receipt workbook with 12 sheets title from left to right July - June. I have one cell for Profit/Loss for each month. I need to have this carried through the entire 12 sheets as a running total. I have had some answers from other groups but either I am too thick or they assume I am really good at this, so I don't understand their answers. Those that looked easy didn't work. I am about intermediate with excel so could anyone please help . Splinter You would probably be better off having two cells - one for the profit or (loss) for the month, and one below that for the running total. Assuming that your month total is in cell C20 and the running total is in cell C21, then do this: In sheet July, in Cell C21 type "=C20" (without the quotes) In sheet Aug, in Cell C21 type "=C20+July!C21" (again without the quotes) Do the same that you did in the Aug sheet, for all the other sheets, just changing the name of the sheet to the one before. HTH -- Interim Systems and Management Accounting www.gbpcomputing.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) | |||
timesheet with running total of overtime | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
how do I keep a running total of my bills? | Charts and Charting in Excel | |||
how do i keep a running total for contributions to several funds | Excel Discussion (Misc queries) |