I hope my title makes sense.
I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the user level. This metric sheet references another master sheet for the totals.
Ultimately what I would love is a table that shows each of the categories from the drop down the contact is associated with.
The formula I am using to grab the totals per category: `
=COUNTIFS({Notice Type 1}, Category@row )
'
"Notice Type 1" is the reference to the drop down menu
Basically what I would like is how many notices Mister User received out of the 1274 total.