jwinstonc said:how do i add every 7 digits in a column? like for weekly data?
jwinstonc said:i want to add groupings of 7. I have individual sales data for each day and want to add each week up indvidually. so I am trying to have a column of weekly sales next to my daily sales. How do I accomplish this?
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
4 | Daily | Weekly | ||||||
5 | Date | WeekNum | Sales | WeekNum | Sales | |||
6 | 12/5/2004 | 50 | 10 | 50 | 102 | |||
7 | 12/6/2004 | 50 | 13 | 51 | 113 | |||
8 | 12/7/2004 | 50 | 19 | 52 | 83 | |||
9 | 12/8/2004 | 50 | 18 | |||||
10 | 12/9/2004 | 50 | 12 | |||||
11 | 12/10/2004 | 50 | 11 | |||||
12 | 12/11/2004 | 50 | 19 | |||||
13 | 12/12/2004 | 51 | 20 | |||||
14 | 12/13/2004 | 51 | 15 | |||||
15 | 12/14/2004 | 51 | 18 | |||||
16 | 12/15/2004 | 51 | 19 | |||||
17 | 12/16/2004 | 51 | 16 | |||||
18 | 12/17/2004 | 51 | 12 | |||||
19 | 12/18/2004 | 51 | 13 | |||||
20 | 12/19/2004 | 52 | 12 | |||||
21 | 12/20/2004 | 52 | 12 | |||||
22 | 12/21/2004 | 52 | 17 | |||||
23 | 12/22/2004 | 52 | 15 | |||||
24 | 12/23/2004 | 52 | 11 | |||||
25 | 12/24/2004 | 52 | 16 | |||||
Sheet3 |