View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bemused
 
Posts: n/a
Default conditional date formula

Hi,
I need to sum data with reference to a specific date range. For example;

I only want to add the dollars that occur between the following date range:
1st of October 2005 - 31st December 2005. My data is presented in columns as
follows:

Date Dollars
dd/mm/yy
20/09/05 $100
01/10/05 $90
01/10/50 $100
03/10/05 $35
15/11/05 $1000
20/12/05 $300
07/01/06 $450

Obviously, the output should be $1525 (90+100+35+1000+300)

Im struggling to find the appropriate conditional array formula.

I'd appreciate any help.

Thanks