Running total between sheets

[hubcapthekknob]

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!

 

[ShaneDevenshire]

Hi,

Without VBA you can write the formula:

=SUM(Sheet1:Sheet10!A3)

 

[Gord Dibben]

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

 

[kknob]

Thanks everyone!!!