Hello,

I have a SUMIF formula and I wonder if we can do this. For example, the formula is SUMIF(Table2[Customer],Summary!$A7,Table2[LW Sale]). Is there a way that I can use drop down list to choose either I want to modify part of the formula from Table2[LW Sale] to Table2[4W Sale], or Table2[YTD]? I want to build a template so it could give me a quick performance review for a time that I want to see under drop down.

Please help and thanks