Hi Thank your reply!


Sorry, I guess there's some error in my attachment. The sheet2 shouldnt have the "Partner Type" and "Partner Tier" fields. Those two fields can only be found in sheet1. So this is where the problems, To solve "How many sales guys i have under country X and Y for Bronze Partner type" cannot be asked only depending on sheet 2. Must combine sheet1 and sheet2. So any more suggestions? Thank you very much.

Quote Originally Posted by Sindhus View Post
For counting based on country and bronze type, you can use
Formula: copy to clipboard 
=countifs(C2:C5,"X",F2:F5,"Bronze")