Formula to pick a date between 2 selected dates in order to add numbers together.

I am trying to create a formula that will basically look at a date that i have in a cell determine wether or not it is in between 2 other dates that i have in 2 other cells and if so add a number that i have in a different cell. If none of the dates are in between the 2 dates I want it to display message.

Ok so that might be very confusing so Im going to give you an example...
A B
1] 10/10/2009 $500
2] 10/20/2009 $600
3] 10/23/2009 $400
4]
5] 10/15/2009 10/25/2009
6]
7] Desired output here in A7


In this case It should say $1000 but i want it to display a message saying like No Data or something if there wasnt anything in that date window i created.

Any help will be appreciated.

O and im using office 2007