Counting & Excluding Cell Totals

[Killer17]

Hey all need help in creating a formula that will keep a running total and exclude cells when new data is entered.

Week 1 new data will be entered starting from cell B34:D34
Week 2 new data will be entered Cell B33:D33
This will continue each week until week 34

Using week 1 (Cell B34:D34) as an example what I need the formula to do, count new data entered plus count everything in Cells B36:D67 excluding data from cells B35: D35 & B68: D68.

Each week I enter this data I want to exclude other two weeks of old data should be removed, the example I have posted should give you an idea of what I’m trying to achieve.

By Week 17 all old data should be excluded and should only be counting current data from Cells B1:D34

The totals I’m trying to achieve are located towards the bottom of the sample sheet.

One other note I ‘m using a formula in Cell B1:D3, this might cause counting problems because it’s returns a zero until the data is entered from other sheet.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
31	4	*	*	*	*	*	*	*	*	*	*	*
32	3	*	*	*	*	*	*	*	*	150	124	147
33	2	*	*	*	*	150	124	147	*	150	124	147
34	1	148	146	150	*	148	146	150	*	148	146	150
35	34	173	152	159	*	173	152	159	*	173	152	159
36	33	175	156	144	*	175	156	144	*	175	156	144
37	32	130	198	143	*	130	198	143	*	130	198	143
38	31	160	144	166	*	160	144	166	*	160	144	166
39	30	140	179	151	*	140	179	151	*	140	179	151
40	29	169	143	152	*	169	143	152	*	169	143	152
41	28	142	156	162	*	142	156	162	*	142	156	162
42	27	188	121	146	*	188	121	146	*	188	121	146
43	26	131	150	174	*	131	150	174	*	131	150	174
44	25	136	148	168	*	136	148	168	*	136	148	168
45	24	167	145	139	*	167	145	139	*	167	145	139
46	23	119	163	166	*	119	163	166	*	119	163	166
47	22	141	157	150	*	141	157	150	*	141	157	150
48	21	135	148	165	*	135	148	165	*	135	148	165
49	20	152	138	156	*	152	138	156	*	152	138	156
50	19	151	155	138	*	151	155	138	*	151	155	138
51	18	142	135	158	*	142	135	158	*	142	135	158
52	17	126	137	168	*	126	137	168	*	126	137	168
53	16	141	160	130	*	141	160	130	*	141	160	130
54	15	141	167	118	*	141	167	118	*	141	167	118
55	14	159	127	139	*	159	127	139	*	159	127	139
56	13	133	145	144	*	133	145	144	*	133	145	144
57	12	129	132	161	*	129	132	161	*	129	132	161
58	11	127	133	160	*	127	133	160	*	127	133	160
59	10	143	135	142	*	143	135	142	*	143	135	142
60	9	105	144	169	*	105	144	169	*	105	144	169
61	8	144	106	168	*	144	106	168	*	144	106	168
62	7	144	140	128	*	144	140	128	*	144	140	128
63	6	137	154	116	*	137	154	116	*	137	154	116
64	5	103	139	152	*	103	139	152	*	103	139	152
65	4	143	119	126	*	143	119	126	*	143	119	126
66	3	106	155	115	*	106	155	115	*	106	155	115
67	2	116	133	123	*	116	133	123	*	116	133	123
68	1	100	144	123	*	100	144	123	*	100	144	123
69	*	Total	14318		*	Total	13892		*	Total	13466
F1

Thanks for the help

 

[Killer17]

Can anyone help me?

 

[Killer17]

Bump