Entering a formula using excel 2003
 

This is my worksheet:

A B C D
row 1 date amount paid bal

row 3 2/28/09 $208.00 $108.00 $100.00
row 4 3/31/09 $260.00 $0.00 $260.00

What I need is a formula that will search for two specific dates, (let's say
the two dates that are above), and give me the sum of the values that
correspond with those two dates. I need it to be able to search for the
specific dates because I'm doing multiple worksheets and the dates might be
in different rows on each worksheet.

Thanks in advance!