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

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

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

"bemused" wrote:

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