View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dpalmer dpalmer is offline
external usenet poster
 
Posts: 1
Default 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!