weekly sales

E

ezemae

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

ezemae

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

Bob Phillips

=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)
 
E

ezemae

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

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top