Hey all,
I need some help with a formula. In the attached spreadsheet, there are 3 tabs:
Inputs
Financials
Data
This is just a sample file I created since I can't post my work file here. But basically, I need to get sum of values for May for example and May YTD based on the selected input in "input" tab.
So for example, in cell D10 in "financials" tab, I would like to link to those cells the arrows are pointing to in my lookup formula and get the sum of all the "pepsi" sold in "US" in May. The selection for month would be pulled from my selection in the input tab cell C12.
PLEASE HELP ME!!!!
Book1.xlsx
Bookmarks