Entering a formula using excel 2003

D

dpalmer

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!
 
Top