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