Previous Topic Next Topic

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

Closed
soni17177 Posts 10 Registration date Wednesday October 10, 2012 Status Member Last seen October 22, 2012 - Oct 10, 2012 at 04:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 10, 2012 at 06:17 PM
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>
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 10, 2012 at 06:17 PM
First what was fault of "ello" in "Hello". You could have shouted that one out like "HELLO" too.

for answer, look into SUMIF function
0