Excel i want to count number of persons in given3diff.conditions

[Closed]
Report
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I am making result sheet where 60 students obtained different marks out of 500 marks now i want to count the number of students in 3 different cells with 3 conditions
1.how much number of students obtained more than or equal to 300 marks.
2.how much number of students obtained more than or equal to 225 marks but less then 300 marks.
3.how much number of students obtained more than or equal to 165 marks but less then 225 marks.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
have you looked into countif ?