Excel.i want to count the number of persons in given 3 condition

[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
-
Hello,
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.
Thanks

<config>Windows XP / Firefox 12.0</config>

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
First what was fault of "ello" in "Hello". You could have shouted that one out like "HELLO" too.

for answer, look into SUMIF function