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