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