stupid sum question

[jwinstonc]

how do i add every 7 digits in a column? like for weekly data?

 

[Brian from Maui]

how do i add every 7 digits in a column? like for weekly data?

Every cell that contains seven digits or every 7th cell in a column?

 

[jwinstonc]

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?

 

[Scott R]

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?

One way is to use WEEKNUM function to group the data for use by the SUMIF function.

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

 

[jwinstonc]

Thanks so much!!