Sum weekly sales

[Akbarov]

Hello Dear community,

I have 2 years sales data , which I need to calculate sum for each week.

I used weekday function,

so from B2:ZR2 I have weekdays. (Monday Tuesday Wednesday Thursday Friday Saturday Sunday)
from B10:ZR68 I have values.
A10:A68 Product names.

How can I get sum of each week? Please help

 

[AlanY]

try this, weekly sum at Row 70

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2		Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
9
10		1	0	0	1	1	0	0	1	0	1	0	0	1	1
11		0	0	0	0	1	1	1	1	0	0	0	1	0	1
12		1	1	0	1	0	1	0	1	1	1	0	0	1	0
13		0	0	0	0	0	0	0	0	1	0	1	0	0	0
14		1	1	1	1	0	0	0	1	0	0	0	0	0	0
15		0	0	1	0	1	1	1	0	0	1	0	0	1	1
16		1	0	1	1	0	1	0	0	0	1	0	0	1	0
17		0	0	0	0	1	0	0	0	0	1	0	1	1	1
18		0	0	0	0	1	0	0	0	1	1	1	0	1	1
19		1	0	0	0	1	1	0	0	0	0	1	0	0	1
20		0	0	0	0	1	1	1	1	0	0	1	1	1	1
21		0	1	0	0	0	1	1	0	1	0	0	1	1	0
22		0	0	0	1	1	1	0	1	1	1	0	0	1	1
23		0	0	0	1	1	1	1	0	0	1	1	1	0	1
24		1	0	1	0	0	0	0	0	1	0	0	0	1	1
25		0	0	0	0	0	1	1	0	1	0	0	0	0	1
26		0	1	1	1	0	0	0	1	1	1	1	0	0	1
27		0	0	1	0	1	1	1	0	1	0	1	0	0	1
28		0	0	0	0	0	1	0	0	1	0	0	0	1	0
29		1	0	0	1	0	1	1	1	0	1	0	1	0	0
30		1	0	1	0	0	1	0	1	0	1	1	1	0	1
31		1	1	0	1	1	1	1	1	0	1	1	0	1	1
32		0	0	1	1	1	0	0	1	0	1	1	1	1	0
33		1	1	1	1	0	0	1	0	0	0	0	0	0	0
34		0	1	0	0	1	0	1	1	0	0	1	1	1	1
35		1	0	1	0	1	1	0	0	0	1	0	0	1	0
36		1	1	1	1	1	0	1	1	1	0	1	1	1	0
37		0	0	0	1	0	0	1	1	1	0	0	0	0	1
38		1	0	0	1	0	1	0	1	0	0	0	0	1	1
39		0	0	0	1	0	0	1	0	0	1	1	1	1	1
40		0	0	0	1	0	0	0	0	0	1	1	0	0	0
41		0	1	1	1	0	0	0	0	1	0	1	1	1	0
42		0	1	1	1	1	1	1	0	1	0	0	1	1	0
43		1	1	0	0	0	1	0	1	0	0	0	0	1	0
44		0	0	0	1	0	0	0	0	1	1	0	1	0	1
45		0	1	1	0	1	1	0	0	1	1	0	0	0	1
46		1	1	0	1	1	0	0	0	0	1	0	0	1	1
47		1	0	1	1	1	0	1	0	0	0	1	0	1	0
48		1	0	1	1	1	0	0	0	1	1	0	1	1	1
49		1	1	1	0	0	0	0	0	1	0	1	1	1	0
50		0	1	0	0	0	1	1	0	0	1	0	0	1	1
51		1	1	1	0	1	1	1	1	0	1	0	0	0	1
52		0	0	0	1	1	1	1	1	0	0	1	1	0	1
53		0	0	0	0	0	0	1	0	1	0	1	0	0	1
54		0	0	0	0	1	0	0	0	0	1	0	0	1	1
55		1	1	0	1	1	1	1	0	0	0	1	0	1	1
56		0	0	1	0	0	1	0	0	1	0	1	0	1	1
57		0	1	0	1	0	1	0	0	1	0	1	1	1	1
58		0	1	1	0	0	0	1	0	0	1	0	0	1	0
59		1	1	0	1	0	0	1	0	1	1	1	0	0	1
60		0	1	0	0	1	1	1	0	1	1	1	1	0	1
61		1	1	0	1	1	1	1	1	1	0	0	0	0	1
62		1	0	0	1	1	1	0	0	0	0	1	1	0	0
63		1	1	0	1	1	0	1	0	1	0	0	0	0	1
64		1	1	1	0	0	0	0	0	1	1	0	1	0	0
65		1	0	1	1	0	0	1	1	1	1	0	1	0	0
66		0	0	1	1	0	1	1	1	0	1	0	1	0	0
67		0	1	1	0	0	0	1	1	1	1	1	1	1	0
68		1	1	1	1	1	0	1	1	0	0	1	0	1	1
69
70		199							201
Sheet4

Cell Formulas
Range	Formula
B70:O70	B70	=IF(B$2="Monday",SUM(OFFSET(B$10,0,0,59,7)),"")

 

[Akbarov]

Thank you, but i need results by each row. How can i do that? A10:A68 are product category names

 

[AlanY]

could you provide a sample data and desired output here