Full Version: Running Total Or Percentile Calculation
jayeshbtrivedi2006
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.
rbianco
Try the CountIf() function
argeedblu
Check out the CountIf() function.

Glenn

Looks like rbianco has a faster trigger finger than I do.
doctor9
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!
jayeshbtrivedi2006
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.
argeedblu
You are welcome Jayesh,

Glenn