I've seen a few examples of similar questions, but none seem to me to be a fit. I would like to summarize the number of scores (# of 1's, # of 2's, etc) given to a vendor when that vendor is chosen. Any help, please. Attached is example.

Thanks,
Tony

Hlookup & Countif Question.xlsx