Complicated multi workbook countifs help

Good morning,

I'm working on a project to compare an item's performance against a set benchmark. Each item is listed in categories and then subcategories based on Year, Geography, and strategy (type). All of the performance data is in one workbook, and the benchmarks are in a separate workbook. I need to come up with a formula which will match an item against its specific benchmark type and then return the number that fit first fit the criteria of being in the top quartile, as well as the number that are in the top half.

I've been struggling with this for a little while and have tried several different approaches including pivot tables and countifs(), but haven't had any luck being able to match up all the subcategories, so any thoughts would be appreciated.

Please see attached. I need to fill in the Yellow cells. I gave a few examples. Let me know what questions you have, and thank you for your time!