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
hi tantcu. you probably know how much a sample excel file can help illustrate better. see if my attachment helps. i intentionally put everything in 1 sheet to see better. it's ok if your reference to Summary sheet is elsewhere.
C7 is your original.
C8 is using INDIRECT
=SUMIF(Table2[Customer],Summary!$A8,INDIRECT("Table2["&B8&"]"))
C9 is using INDEX & MATCH (much preferred as INDIRECT is volatile:
=SUMIF(Table2[Customer],Summary!$A9,INDEX(Table2[[LW Sale]:[YTD]],,MATCH(Summary!B9,Table2[[#Headers],[LW Sale]:[YTD]],0)))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks