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.

Give us an example

Tyro

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

Weekly Info Worksheet column c is where I want the weekly sales to display. I
get the amounts from "daily Info" worksheet that has all the daily sales in
column C. Column A has "day" for day of week. I need to get daily sales from
Wed to Tues to add up each week and display them in column c for the
corresponding week in "weekly info".

"Tyro" wrote:

Give us an example

Tyro

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

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

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.

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.