Using Countifs to compare lists

[Walkon]

I have two tables, one each on separate sheets. The first is a list of applicants - each with a unique identifying number.

The second is a list of references for those applicants. The references include the unique number of their applicant.

I'd like to include a column on the sheet of applicants that identifies the number of references that have been received for each applicant.

 

[kevin9999]

You can't see your headings in you image (please consider using the XL2BB add in in future) so let's assume the titles in both tables are "Applicants" and that the second table is called "Table2".

Book1
	A	B	C
1	Applicants	Name	Count
2	62909450	name	2
3	92437741	name	3
4	71224686	name	2
5	44067138	name	3
6	74812307	name	3
7	61318561	name	3
8	40572917	name	4
9	81623655	name	1
10	92918889	name	1
11	69927076	name	1
12	71720190	name	1
13	62602267	name	1
14	94840400	name	1
15	87762940	name	1
16	29266193	name	1
17
Sheet1

Cell Formulas
Range	Formula
C2:C16	C2	=COUNTIF(Table2[Applicants],[@Applicants])

 

[Walkon]

I have two tables, one each on separate sheets. The first is a list of applicants - each with a unique identifying number.
View attachment 103097
The second is a list of references for those applicants. The references include the unique number of their applicant.
View attachment 103099

I'd like to include a column on the sheet of applicants that identifies the number of references that have been received for each applicant.

Thank-you very much for the help! My apologies for the poor images/descriptions.

 

[kevin9999]

You're welcome & thanks for the feedback