Hi all,

I am currently making an inventory and am trying to get some stats going on the data but don't know how to count the exceptions.

I'm trying to count the # of people who are assigned to a cabinet. We have broken it down by cabinet (numbered) and drawers (lettered). The problem I'm running into is if one cabinet has multiple owners. I don't want to count of the cabinet to be off but I would like to show a summary of how many cabinets each person owns. I've put everything into a Pivot Table and have a hidden column that only has the Cabinet #s once and the PivotTable uses those to count the # of cabinets per person. However, the problem I'm having is that if drawer B or C is owned by another person, those aren't being accounted for when breaking down by owner. Basically, I don't want a breakdown of the # of drawers each person owns, I just want a summary showing the # of cabinets they are shown under. If one person owns all the drawers in the cabinet, it should show as 1. However, if there are two names, each name should have 1.

Any help would be appreciated!
Capture.PNG