conditional date formula

[bemused]

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

 

[RagDyer]

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

 

[bpeltzer]

If the data is in A2:B8, =sumif(a2:a8,">=" & date(2005,10,1),b2:b8) -
sumif(a2:a8,">=" & date(2006,1,1),b2:b8).
That is, add up all the entries corresponding to dates on/after 10/1/05,
then subtract all those on/after 1/1/06. Those left are the ones in your
range.
--Bruce