Data Change based on 2 Different Drop Down Lists

[emack1230]

1st thank you in advance, this forum has been a life saver multiple times.

My issue: I am tracking employee turnover with data showing the different positions of employees and how many have terminated. I am wanting our table to auto change the numbers based on 1) Fiscal Year in a drop down list, then 2) what week of that fiscal year. Have played with different countifs and ifs, and just seems very complicated to do it that way and haven't gotten it to work. Thanks gain.

 

[emack1230]

yes pivot table may work , when i worked in performance improvement & change management - we used those a lot , but going back into 90's - but would be useful to have the data examples - not loads , and without names ,

you can use things like COUNTIFS() SUMIFS() maybe INDIRECT()
But the data would need to be in a format which works ok for those functions

In this file we have about 15 different tabs tracking different stuff. Many of the formulas are countifs and regular if statements. We haven't tried the indirect yet, still a little green with that one. I will see if I can get any of that other data for an example.