Hey Thomas,

No formula needed if you learn how to do Pivot Tables. See the attached.

Pivot Table to Count different Info in B.xlsx