I lose my mind to trying calculate this

[moogeedoo2]

Excel Emperors,
Greetings,,,


I lose my mind to trying calculate this, I have this table below and I try to extract how many indian student are in the highest 25% of scores. or in other way: I have 12 student. 25% of them = 3 I want to know who are the highest 3 students in the score and then how many indians students in these 3 students. in one formula. anyone HELP PLZ.

student ID	student name	nationality	score	class
4983	Jhon	india	51	2
3517	edward	india	64	3
2834	peter	Yemeni	57	11
5167	adam	Egyptian	59	7
2074	amanda	Pakistani	72	7
1050	younes	Jordanian	48	2
3337	arnel	Palestinian	86	8
5672	Jhoseph	Indian	74	3
1082	jannet	Palestinian	51	2
5143	kaila	Yemeni	80	11
5234	inka	algeria	54	2
1506	idward	Palestinian	77	8

<tbody>
</tbody>

 

[Dave Patton]

=SUMPRODUCT(--(D2:D13>=LARGE(D2:D13,3)),--(C2:C13="indian"))

 

[moogeedoo2]

well done Dave excellent, its working perfectly, sorry for more inconvenience, but if i want to extract how many indians student are in the highest 25% of scores in a specific class for example class 2 How can I add it to your magical formula?!

 

[moogeedoo2]

=SUMPRODUCT(--(D2:D13>=LARGE(D2:D13,3)),--(C2:C13="indian"))

well done Dave excellent, its working perfectly, sorry for more inconvenience, but if i want to extract how many indians student are in the highest 25% of scores in a specific class for example class 2 How can I add it to your magical formula?!

 

[Dave Patton]

=SUMPRODUCT(--(D3:D14>=48),--(C3:C14="indian"),--(E3:E14=2))