Help with CountIFs formula
I am trying to use the CountIFs formula to calculate the number of times each category in a drop down list appears in one column. I'd also like to be able to make sure the items are only being counted are in Hierarchy level 2. Below is the list of categories, can anyone please help me understand writing the formula? I will be referencing another sheet for this formula as well, I'm writing the formula on my metrics sheet and the categories are on my main project tracking sheet.