Hi,
I am trying to create a formula which does the following.
Providing the two criteria to match
=COUNTIFS(B2:B59, 2, C2:C59, 4)
Where 2 = CPU and 4 = Mem
I want to list in Column G which has a list of roles in Cell G2:G7 that the corresponding cell count in F2:F7 matched
Bookmarks