How to count the number of occurence of a distinct employee?

[harithad95156]

 

For example: First 3 rows should display 3,3,3 in count. Any suggestion will be greatly appreciated 🙂

[RsQK]

Hey, try this:

=COUNT(TOTAL <employees> DISTINCT category)