Roger,

I followed your instructions but the result is zero for each week:

WE WE WE WE WE WE WE
09/29/06 10/06/06 10/13/06 10/20/06 10/27/06 11/03/06 11/10/06 11/17/06
Cash Receipt 0 0 0 0 0 0 0


The formula I used:

=SUMPRODUCT(('Raw Data Sheet'!$A$1:$A$1000B$2))*('Raw Data Sheet'!$A$1:$A$1000<=C$2)*((('Raw Data Sheet'!$D$1:$D$1000)))

If you can please shed some light on the error.

Shahid




"Roger Govier" wrote in message ...
Hi

Assuming the heading Cash Receipt on Summary is in cell A3
In cell A2 enter 09/29/2006
Format the cell with Font White so it doesn't show.

In B2 enter
=SUMPRODUCT(('Raw Data Sheet'!$A$1:$A$1000B$2)*('Raw Data Sheet'!$A$1:$A$1000<=C$2)*((('Raw Data Sheet'!$D$1:$D$1000))
Copy across through C2:F2
--
Regards

Roger Govier


"SSJ" wrote in message ...
Hello!

1) The RAW DATA SHEET is where I maintain a cash receipt register in a list form on a daily basis. Any date may have multiple entries due to different customer payment.
2) The SUMMARY SHEET shows how I want to summarize the data contained in RAW DATA SHEET. Basically the summary sheet is summing based on the date grouped in weeks.

RAW DATA SHEET
DATE DAY CUSTOMER AMOUNT
9/30/2006 Sat
10/1/2006 Sun
10/2/2006 Mon A 100
10/2/2006 Mon K 110
10/3/2006 Tue B 120
10/4/2006 Wed A 130
10/5/2006 Thu C 140
10/6/2006 Fri B 150
10/7/2006 Sat
10/8/2006 Sun
10/9/2006 Mon A 200
10/10/2006 Tue K 210
10/11/2006 Wed B 220
10/12/2006 Thu A 230
10/13/2006 Fri C 240


SUMMARY SHEET

Week Ending Week Ending Week Ending Week Ending
10/6/2006 10/13/2006 10/20/2006 10/27/2006
Cash Receipt 750.00 1,100.00