Finding students standard rank.
Hello Every One.
I am preparing Students Marks Lists. I Need Standard Rank Combined Two Worksheets (Sheet1: XI and Sheet2: XI C GROUP). I am using countifs functions but display result Like this "#VALUE!". I am attached My Excel sheet . Please Help Me.
=IF($J2="Fail",0,COUNTIFS($J$2:$J$35,"Pass",$I$2:$I$35,">"&I2)+1)
* Ranges must be the same size
** "0" is not 0
!! How can you compute an average score for a student by summing the scores of all students...
!!! You're using the column headers in your sum/count ranges???
Last edited by protonLeah; 09-07-2019 at 05:08 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks