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.