One way ..

Assume the marks are listed within B2:B100

Enter in C1: 50, in D1: 60

Then put in E1:
=SUMPRODUCT(($B$2:$B$100C1)*($B$2:$B$100<D1))

E1 will return the required count of students with marks 50 & < 60

Adapt to suit ..

We could also copy E1 down to return other corresponding counts for other
ranges of marks by inputting the required mark limits in C2:D2, C3:D3, etc
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Sarath.Ch" wrote in message
...
hi...
Sir,

For Eg: i have 1000 students...i entered marks to all the students now i
need to fine the total students who have score 50 and <60 in each
subject..