I have been trying to develop a couple of functions that use the INDIRECT function.
I have been passing cells to indirect to retrieve multiple sheets, like:
Sheet Names
Jan | Feb | Mar | Apr | May etc....
I want to sum the cell A208 across three sheets ex. quarterly total
And I want to do it dynamically so user can choose "dropdown" which quarter total they want to view.
So in Sheet "Qtr Totals" I would have A1 = Jan:Mar or Apr:Jun
Then function would be
=SUM(INDIRECT(A1&"!A208"))
However, function gives #VALUE or #REF.
Any insight greatly appreciated.
Bookmarks