I want to Sum or Average or other function based on the selection in another cell. I have a Cell D36 that contains the formula =INDIRECT(D35) & (D30:D34), D35 contains the reference $B$36, that cell is a drop down containing the possible options for Average/Sum/etc. I would like the result to a be a formula like =Sum(D30:D34). Instead I get the results as an array with a $Spill error since there is data below when I only need the result of the formula.
Any help would be appreciated.
Bookmarks