Number of specific item sold per Sales Team Member


On my Inventory Table, I have my primary field as Name of Product and a lookup field of Sales Team Members that have sold that specific item (linked from a Multi Select)
Is there a way that I can then take that Sales Team Member column and know how many of that specific item each team member sold?

Product Name… Sales Team Member
Stapler… Joe, Joe, Joe, Bob, Karen


I’ve tried to solve your problem taking into account your data structure but I couldn’t find a clean solution.
I think you need at least a third table to link your orders (or sales) with your team members and inventory.

Using blocks (if you have a premium plan) is pretty easy to solve using a pivot table.

Here are my tests:

Hope it helps.



Thank you so much! I’m pretty close to the formula I need, but not all of the fields are populating. The similarity in unpopulated fields in that those all have multiple sales team members, but those that only have 1 name are populating!!! For instance I can see that a total of 6 Amelia-3 S were sold, and Rachel and Mandee were the members that sold them, but I can’t break down how many of each belong to who. Capture2