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!

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!

Running total between sheets
 

Add a sheet at beginning.

Add a sheet at end.

Name these Start and End

In master sheet enter =SUM(Start:End!A3)

If you want to add more sheets, insert them between Start and End.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:17:54 -0800 (PST), 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!

Running total between sheets
 

Thanks everyone!!!