Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total between sheets
Hi, I know some about Excel but I need help. Thanks in advance!
I am trying to keep a running total on a "Master Sheet". The other worksheets would have a cell that i would need to summed up between all the sheets and outputted on the Master sheet. for example: Sheet1 A3 + Sheet2 A3 + Sheet3 A3......... the macro i have already is: Function SumTotal() Const r = "A1" Dim ST As Range t = 0 For i = 1 To 3 Set ST = Sheets(i).Range(r) t = t + ST.Value Next i SumTotal = t End Function This works fine, The number of sheets i would have would be around 250.... I'm sort of using this as a form that the user would record an incident on a sheet and would keep a running total of certain things on the Master Sheet. If anyone knows of any easier way of doing this, please help. Thanks! also, would I be able to name the Sheets and still be able to work for example Sheet1 = master, Sheet2 = Incident1, Sheet3 = Incident2....etc etc. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total between sheets
Hi,
Without VBA you can write the formula: =SUM(Sheet1:Sheet10!A3) -- Thanks, Shane Devenshire " wrote: Hi, I know some about Excel but I need help. Thanks in advance! I am trying to keep a running total on a "Master Sheet". The other worksheets would have a cell that i would need to summed up between all the sheets and outputted on the Master sheet. for example: Sheet1 A3 + Sheet2 A3 + Sheet3 A3......... the macro i have already is: Function SumTotal() Const r = "A1" Dim ST As Range t = 0 For i = 1 To 3 Set ST = Sheets(i).Range(r) t = t + ST.Value Next i SumTotal = t End Function This works fine, The number of sheets i would have would be around 250.... I'm sort of using this as a form that the user would record an incident on a sheet and would keep a running total of certain things on the Master Sheet. If anyone knows of any easier way of doing this, please help. Thanks! also, would I be able to name the Sheets and still be able to work for example Sheet1 = master, Sheet2 = Incident1, Sheet3 = Incident2....etc etc. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total between sheets
Thanks everyone!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total from the same field on multiple sheets as i add she | Excel Worksheet Functions | |||
How do I add totals up from different sheets? A running total. | Excel Worksheet Functions | |||
Running Total | Excel Worksheet Functions |