Need help with counting data with multiple criteria, when one criteria has duplicates

[rkallen2]

I have the following data:
List of employees (Column A)
Department for each employee (Column B)
Training course completed (Column C)
Course Category (Column D)


Trying to solve for the following:
How many *employees* have completed a course in each course category by department.

I have solved for how many courses in each category have been completed by department using COUNTIFS, but because one employee can complete multiple courses in the same category, this count returned a higher value than the number of people who completed a course in each category.

I am unable to figure out how determine because employees names show up multiple times for the same course category.

Attached a sample of the data.

Please help!

 

[mart37]

You can use a pivot table.
Important: Add data to data model then you can choose by functions for DISTINCT COUNT
Help for Distinct Count

 

[mart37]

Map7
	A	B	C	D		F	G	H	I	J	K	L	M	N
1	Employee	Department	Course Category						Unieke telling van Employee	Kolomlabels
2	1	Financial Counseling	Registration						Rijlabels	Admissions	HIM	Pre-2019 Epci Upgrade	Registration	Scheduling
3	1	Financial Counseling	Scheduling						Emergency Registration	1		1	1	1
4	1	Financial Counseling	Registration						Financial Counseling	1		1	2	1
5	1	Financial Counseling	Scheduling						Health Infomation Management		1	1
6	1	Financial Counseling	Registration						Eindtotaal	2	1	3	3	2
7	1	Financial Counseling	Admissions
8	1	Financial Counseling	Scheduling
9	1	Financial Counseling	Pre-2019 Epci Upgrade
10	2	Emergency Registration	Admissions
11	2	Emergency Registration	Scheduling
12	2	Emergency Registration	Registration
13	2	Emergency Registration	Scheduling
14	2	Emergency Registration	Registration
15	2	Emergency Registration	Registration
16	2	Emergency Registration	Registration
17	2	Emergency Registration	Registration
18	2	Emergency Registration	Admissions
19	2	Emergency Registration	Pre-2019 Epci Upgrade
20	3	Health Infomation Management	Pre-2019 Epci Upgrade
21	3	Health Infomation Management	HIM
22	4	Financial Counseling	Registration
23	4	Financial Counseling	Registration
Blad1