I have a spreadsheet with data for the last 3 years by day.

Column A contains the date and columns B–C contains numeric and text data.

I am looking for a formula that will sum the data in Column B-C based on a beginning and ending date. I need do this for each week of the last 3 years.

I did this formula and it gave me a value reference.

=SUMPRODUCT(('FY 2006'!$A$8:$A$550=C$4)*('FY 2006'!$A$8:$A$550<=C$5)*('FY 2006'!$B$8:$B$550))

C4 = 12/25/05
C5 = 1/1/06.

Any help provided is appreciated.

Thanks.