Need Help with a Date Sum Product

[Frick]

I have attached a small worksheet that explains my two problems.

My first problem. In one column I have various dates entered, in the
next column are numbers. What I need to be able to do is based on a
start and end date, I need to find all the data within the date range.

My second problem. I need to drop either 1,2, or 3 lowest scores
either based on all the data in each column (this is easy formula and
I've done that) or based on the date range.

Thanks for all help offered. I hope I have sufficiently explained my
problems.


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

 

[Frick]

wjohnson. Thanks for the help. The formulas work fine. Did you have
chance to look at the second problem and if so any ideas how to solv
it

 

[wjohnson]

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 th
lowest number 1st.
2nd column is an 'AND" column to verify your 2 conditions -
condition 1 - "What Semester" and Condition 2 - "What Ranking" you d
not want.

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

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

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