Matching cells, comparing values and producing total

[MrsTeach]

I'm a teacher working on a huge data set in a multi-academy trust on pupil progression. My Excel is very rusty and I'd appreciate any help on trying to find the total number of all female sets (ability groups) in our schools.

Here's a mock-up of the data. The real set has many more column entries and around 10k rows so I'm trying to find the neatest function or macro. Any help would be much appreciated.

Book1
	A	B	C	D
1	Set ID	Pupil ID	Sex
2	1	1111	1
3	1	2222	1
4	1	3333	2
5	1	4444	1
6	2	5555	2
7	2	6666	1
8	2	7777	2
9	2	8888	2
10	3	9999	1
11	3	1000	2
12	3	1100	1
13
14	Total Number of All Female Sets (Where female = 2)
15
16
Data

 

[JamesCanale]

=LET(z,A2:A12,y,C2:C12,a,UNIQUE(z),b,SUMIFS(y,z,a),c,COUNTIFS(z,a),d,b/c,SUM(--(d=2)))

 

[MrsTeach]

=LET(z,A2:A12,y,C2:C12,a,UNIQUE(z),b,SUMIFS(y,z,a),c,COUNTIFS(z,a),d,b/c,SUM(--(d=2)))

Thank you so much. You've been a life saver!

 

[JamesCanale]

It's good fun.

This only works correctly if column C is only 1 or 2 and no blanks or other options that are increasingly popular these days.