I have two lookup formulas that return cell references that I'd like to use in a Sum() function, but it doesn't work.
The formulas are:
=ADDRESS(MATCH(J5,DailyGrowthTable[Date],0)+11,3) which returns $C$822
and
=ADDRESS(MATCH(LOOKUP(2,1/(DateColumn<>""),DateColumn),DailyGrowthTable[Date],0)+11,3) which returns $C$1246
If I use =SUM($C$822:$C$1246) it works and returns 12,496 which is correct.
But if I replace the cell references in the Sum() function with the formulas, it doesn't work
=SUM(ADDRESS(MATCH(J5,DailyGrowthTable[Date],0)+11,3):ADDRESS(MATCH(LOOKUP(2,1/(DateColumn<>""),DateColumn),DailyGrowthTable[Date],0)+11,3)) returns #N/A.
Bookmarks