CountIf Parent Hierarchy Column and Secondary Column
I apologize if this has been asked. I am trying to figure out a Countif formula combined 2 columns.
Column 1 is a hierarchy level column in 5 levels (0=great-grandparent, 1=grandparent, 2=grandparent, 3=child, 4=child).
Column 2 is a internal priority level with 4 levels (High, Medium, Low, N/A).
I want to get count of all the levels at the child level but in groups (how many high, how many medium and so forth.
I have only figured out how to do the grand count total for all in Column 1
=COUNTIF([Column 1]1:[Column 1]308, 3) = 70.
But how do I do the combined CountIF?
In English it would say, if Column 1 is equal to 3, then count "High" in Column 2.
I would have 4 of these formlas (for each level) and these 4 should equal 70.
Help Article Resources
Check out the Formula Handbook template!