Stack quest - SUMIFS - Google Sheets

	A	B	C	D	F
1
2	Today:	Sat, 6 May			300
3		Person
4		chest	abs
5	Week Target	420	600
6	Week Avg	0	0	<- these cells should be not zero
7	Sun, 25 Sep	10	300
8	Mon, 26 Sep	20	290		0
9	Tue, 27 Sep	30	280
10	Wed, 28 Sep	40	270
11	Thu, 29 Sep	50	260
12	Fri, 30 Sep	60	250
13	Sat, 1 Oct	70	240
14	Sun, 2 Oct	80	230
15	Mon, 3 Oct	90	220
16	Tue, 4 Oct	100	210
17	Wed, 5 Oct	110	200
18	Thu, 6 Oct	120	190
19	Fri, 7 Oct	130	180
20	Sat, 8 Oct	140	170
21	Sun, 9 Oct	150	160
22	Mon, 10 Oct	160	150
23	Tue, 11 Oct	170	140
24	Wed, 12 Oct	180	130
25	Thu, 13 Oct	190	120
26	Fri, 14 Oct	200	110
27	Sat, 15 Oct	210	100
28	Sun, 16 Oct	0	0
29	Mon, 17 Oct	0	0
30	Tue, 18 Oct	0	0
31	Wed, 19 Oct	0	0
32	Thu, 20 Oct	0	0
33	Fri, 21 Oct	0	0
34	Sat, 22 Oct	0	0
35	Sun, 23 Oct	0	0
36	Mon, 24 Oct	0	0
37	Tue, 25 Oct	0	0
38	Wed, 26 Oct	0	0
39	Thu, 27 Oct	0	0
40	Fri, 28 Oct	0	0
41	Sat, 29 Oct	0	0
42	Sun, 30 Oct	0	0
43	Mon, 31 Oct	0	0
44	Tue, 1 Nov	0	0
45	Wed, 2 Nov	0	0
46	Thu, 3 Nov	0	0
47	Fri, 4 Nov	0	0
48	Sat, 5 Nov	0	0
49	Sun, 6 Nov	0	0
50	Mon, 7 Nov	0	0
51	Tue, 8 Nov	0	0
52	Wed, 9 Nov	0	0
53	Thu, 10 Nov	0	0
54	Fri, 11 Nov	0	0
55	Sat, 12 Nov	0	0
56	Sun, 13 Nov	0	0
57	Mon, 14 Nov	0	0
58	Tue, 15 Nov	0	0
59	Wed, 16 Nov	0	0
60	Thu, 17 Nov	0	0
61	Fri, 18 Nov	0	0
62	Sat, 19 Nov	0	0
63	Sun, 20 Nov	0	0
64	Mon, 21 Nov	0	0
65	Tue, 22 Nov	0	0
66	Wed, 23 Nov	0	0
67	Thu, 24 Nov	0	0
68	Fri, 25 Nov	0	0
69	Sat, 26 Nov	0	0
70	Sun, 27 Nov	0	0
71	Mon, 28 Nov	0	0
72	Tue, 29 Nov	0	0
73	Wed, 30 Nov	0	0
74	Thu, 1 Dec	0	0
75	Fri, 2 Dec	0	0
76	Sat, 3 Dec	0	0
77	Sun, 4 Dec	0	0
78	Mon, 5 Dec	0	0
79	Tue, 6 Dec	0	0
80	Wed, 7 Dec	0	0
81	Thu, 8 Dec	0	0
82	Fri, 9 Dec	0	0
83	Sat, 10 Dec	0	0
84	Sun, 11 Dec	0	0
85	Mon, 12 Dec	0	0
86	Tue, 13 Dec	0	0
87	Wed, 14 Dec	0	0
88	Thu, 15 Dec	0	0
89	Fri, 16 Dec	0	0
90	Sat, 17 Dec	0	0
91	Sun, 18 Dec	0	0
92	Mon, 19 Dec	0	0
93	Tue, 20 Dec	0	0
94	Wed, 21 Dec	0	0
95	Thu, 22 Dec	0	0
96	Fri, 23 Dec	0	0
97	Sat, 24 Dec	0	0
98
99
100