Try,

=SUM(INDIRECT(A1 & "!" & "E19:G19"))

Drag down as required

Mike

"Ernst - EXE Graphics" wrote:

Thanks Mike. That does the trick. Another question:

Now I have a list of names and I want to use the list with a formula to
calculate values from the sheet in the list:

sheet1 =+'sheet1'!E19+'sheet1'!G19
sheet2 =+'sheet2'!E19+'sheet2'!G19

How can I get the formula to get the sheet name from the list that was
created?


"Mike H" wrote:

Hi,

Right click the sheet tab of the 'other' sheet, View code and paste this in
and run it

Sub standard()
Dim x As Long
For x = 1 To Worksheets.Count
Cells(x, 1).Value = Sheets(x).Name
Next
End Sub

Mike

"Ernst - EXE Graphics" wrote:

I have a file with about 80 worksheets. How can I create a list in another
sheet that reflects all the sheet names