Dear All,

I am attaching a file.

I want some fromula by which I can count the no. of students having marks less then the studen score.

Thanks.

Jayesh.

Try the CountIf() function

Check out the CountIf() function.

Glenn

Looks like rbianco has a faster trigger finger than I do.

jayeshbtrivedi2006,

To get the number of students that got a lesser score, use the RANK function, and subtract 1.

For example, if you have a list of scores in B2:B7, your formula to find the number of students with lower scores than B4 would be:

=RANK(B4,B$2:B$7,1)-1

Hope this helps,

Dennis

EDIT: Ha! You guys may be faster, but my idea is... well, DIFFERENT!

Dear Rabianco,Glen and Dennis,

Thanks for the quick reply but I was out of station so could not replied soon.

The rank function has fullfilled my requierment and I will also try the countif.

Thanks again regards.

Jayesh.

You are welcome Jayesh,

Glenn