=SUMPRODUCT(--(Sheet1!A2:A200=--"2008-01-07"),--(Sheet1!A2:A200<--"2008-01-14"),Sheet1!B2:B200)

etc.

Note that you cannot use a whole column in SUMPRODUCT (prior to excel 2007),
but must use an explicit range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ezemae" wrote in message
...
I need help. I am working with two sheets. In one sheet I have all the
daily
sales. In another sheet I want to have weekly sales. How do I get Excel to
add up 7 days of sales to get a weekly sales figure. I don't want to keep
entering formulas. I want to be able to copy them instead of entering them
all.