I can easily sum a given cell, say B9, across multiple worksheets with something like:
This is the equivalent to :
Which is the sum of cell B9 in all the worksheets from Sheet7 through Sheet11.
I need to create something like the first formula, but with the sheet names in cells. So if A1 contains:
and cell A2 contains:
Then the formula in A3 would use these cells. What I have tried so far is:
=SUM(A1 & ":" & A2 & "!" & B9)
=SUM(INDIRECT(A1 & ":" & A2 & "!" & B9))
Neither of these work.
I can easily create a VBA function to do this, but the workbook must be able to operate in a macro-free environment.