I have a sheet where column C list all my different dealers. In column K it list the buyers and if not sold, I put a NS. What formula would be used to calculate for each Dealer in C how many sold items in K. In other words, I would like to know how many times a dealer in C listed and how many times there is a sold name in K other than a NS?
TY
TY