Subtotal Non-Unique Items By Employee

I have a list of sales associates by items by manufacturer. I need to count how many manufacturers are represented by each associate. It might look something like this:

Smith, John Brand A Beer 12 oz Beer Industries, Inc.
Smith, John Brand A Beer 8 oz Beer Industries, Inc.
Smith, John Brand B Vodka 700ml Vodka Industries
Jacobs, Sally Brand C Wine 1989 Wine Makers Co
Jacobs, Sally Brand C Wine 1979 Wine Makers, Inc.
Jacobs, Sally Brand D Wine 1908 Old Wine Makers, Ltd.
Jacobs, Sally Brand E Beer Six Pack Fun Beer Co.

So the totals would be:

Smith, John Total # of Manufacturers: 2
Jacobs, Sally Total # of Manufacturers: 3

So the formula ignores the duplication in employee names and manufacturer names.

Is this possible? I'm thinking something like =sumproduct((Range=AssociateName)*(sum(1/countif(ManufacturerRange, ManufacturerRange)))