Hi All I hope you can help.
Attached is a screenshot which I hope will explain it.
The formula I have is =SUM('1:31'!D24)
What I need to be able to do is to have the sheet names come from entries in cells.
ie. =SUM('B20:D20'!D24)
So if someone types 3 in B20 and 10 in D20 it will sum cells D24 from sheets 3 to 10.
How can I do this?
Bookmarks