Hi, I need help.

Question 1. I want to have a formula that can automatically sum the amount
in columm 'D when date in columm 'C' meet my requirement. Normally, I just
want to know the total qty in particular month. Please refer to table below.
What formula I need to have to return the total qty based on different Part
Name and different Month? Eg. I want to know the total qty of Screw AB
required for the month of Jan. Columm 'A' contains more than 1,500 different
part name.

Question 2. A formula to return the furthest delivery date per a
particular part. Eg. I want the furthest delivery date for Screw AB, the
answer is 6-Feb-07.

Normally I have to do calculation by using sum, drag manually.... more than
1,500 parts.... Weekly... more chances to human error..


A B C D
1 Part name stock Delivery date PO QTY
2 Screw AB 55,000 1-Jan-07 12,000
3 2-Jan-07 10,000
4 3-Jan-07 10,000
5 4-Feb-07 10,000
6 5-Feb-07 10,000
7 6-Feb-07 10,000
8 Screw MN 60,000 1-Jan-07 12,000
9 2-Jan-07 10,000
10 3-Jan-07 10,000
11 4-Feb-07 10,000
12 5-Feb-07 10,000
13 6-Feb-07 10,000


Thanks in advance..
Sara