Hello. I have a complex formula I need help with and struggling. Here is my
data:

A B C
1 1/1/2009 Chicago $5.00
2 1/2/2009 New York $7.00
3 2/2/2009 New York $5.00
4 2/15/2009 Chicago $9.00

Here's the struggle. Suppose I want to know shipments from January 1st to
February 1st (A) that went to New York (B) and the sum of all delivery
charges (C). It's the dates column giving me the most trouble because I am
trying to create a range (ie. all dates between 1/1/09 and 2/1/09)

Can anyone assist?? Any help would be appreciated.