I have a formula which sums all consecutive sheets:
=SUM('1:41'!AJ49)
Is there any way in which I can have a cell, say G2, which determines which gets summed. E.g. If I was to type in cell G2 “1:10” it would sum sheets 1 to 10.
Is this possible?
I have uploaded an example
Paul
Bookmarks