Hi,
I have a formula like this:
SUM(Sheet2!A1:A5) in an excel sheet. I want to replace "2" in Sheet2 by a cell reference (A1) so that the formula automatically adjusts to get the required result, when the user want the sum from a random sheet.
So, my current formula is this: =SUM(Sheet2!A1:A5)
And I want something like this: =SUM(Sheet(A1)!A1:A5)
Is this possible? How? Please help me.
Bookmarks