I want to count the number of unique values a column based on COUNTIFS.

[maxim642]

I have sickness data, and I want to know how many different colleagues were sick each month. My data includes duplicate values for employee ID as there have been multiple occasions throughout the year that they have been off. I don't want to use a pivot table. Below is an example of my data.

I want to know how many different employees were off in Oct 2021. So unique employee numbers (emp1, emp2 etc.) that are "2021" & "Oct". Thank you.

Emp1	2021	Jan
Emp2	2019	Feb
Emp3	2021	Oct
Emp1	2021	Oct
Emp1	2021	Oct
Emp2	2021	Apr
Emp2	2020	Nov
Emp3	2021	Oct
Emp1	2020	Oct

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(A2:A100,(B2:B100="2021")*(C2:C100="Oct"))))

 

[maxim642]

How about

=ROWS(UNIQUE(FILTER(A2:A100,(B2:B100="2021")*(C2:C100="Oct"))))

Thank you. This worked!

 

[Fluff]

You're welcome & thanks for the feedback.