Previous Topic Next Topic

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

Closed
soni17177 Posts 10 Registration date Wednesday October 10, 2012 Status Member Last seen October 22, 2012 - Oct 11, 2012 at 05:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2012 at 05:27 PM
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.



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 11, 2012 at 05:27 PM
have you looked into countif ?
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses