I am able to make it work but 2 more columns were added
I added a "RANK" column to rank the values in Reverse order to rank the
lowest number 1st.
2nd column is an 'AND" column to verify your 2 conditions -
condition 1 - "What Semester" and Condition 2 - "What Ranking" you do
not want.

Then I did a "sumif" and everything seemed to work.

I have attached your spreadsheet with my additions highlighted in
"yellow" and "bold"


+-------------------------------------------------------------------+
|Filename: Example1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4127 |
+-------------------------------------------------------------------+

--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=493413