using countifs and indirect based on your drop down.
look attachment

test (2).xlsm