Dates in ColumnA, dollars in Column B.

Starting date of range in C1,
Ending date of range in C2.

Try this:

=SUMPRODUCT((A1:A100=C1)*(A1:A100<=C2)*B1:B100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"bemused" wrote in message
...
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