The format is totally irrelevant as long as they are dates.

--
---
HTH

Bob


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



"ezemae" wrote in message
...
I am so lost! I am using Excel 2003 and my dates are not in that format. I
have in the first cell 1/01/2008. The cell under it is B1+1.


"Bob Phillips" wrote:

=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.