Creating an average

[RainerJonker]

I want to create a Average for the percentages but only as it is filled in. So if its filled in till week 5 the average shows till week 5, if its filled in till week 10, the average is filled in till week 10

SRP Test 1.xlsx
	A	B	C	D	E
1		Production
2
3		Tons of Final Product:
4
5			Benchmark	7000
6			Weight	5.70%
7
8			Shift A:
9
10		Weeks:	Input Values:	% Towards Total:
11		1	7000	5.70%
12		2	2000	1.63%
13		3	20	0.02%
14		4	2345	1.91%
15		5	7000	5.70%
16		6		0.00%
17		7		0.00%
18		8		0.00%
19		9		0.00%
20		10		0.00%
21		11		0.00%
22		12		0.00%
23		13		0.00%
24		14		0.00%
25		15		0.00%
26		16		0.00%
27		17		0.00%
28		18		0.00%
29		19		0.00%
30		20		0.00%
31		21		0.00%
32		22		0.00%
33		23		0.00%
34		24		0.00%
35		25		0.00%
36		26		0.00%
37		27		0.00%
38		28		0.00%
39		29		0.00%
40		30		0.00%
41		31		0.00%
42		32		0.00%
43		33		0.00%
44		34		0.00%
45		35		0.00%
46		36		0.00%
47		37		0.00%
48		38		0.00%
49		39		0.00%
50		40		0.00%
51		41		0.00%
52		42		0.00%
53		43		0.00%
54		44		0.00%
55		45		0.00%
56		46		0.00%
57		47		0.00%
58		48		0.00%
59		49		0.00%
60		50		0.00%
61		51		0.00%
62		52		0.00%
63
64		Average weight:
65
66
Sheet3

Cell Formulas
Range	Formula
D11:D62	D11	=C11/$D$5*$D$6

 

[earthworm]

Is this is what you want ?

Book1
	B	C	D
8		Shift A:
9
10	Weeks:	Input Values:	% Towards Total:
11	1	7000	5.70%
12	2	2000	1.63%
13	3	20	0.02%
14	4	2345	1.91%
15	5	7000	5.70%
16	6
17	7
18	8
19	9
20	10
21	11
22	12
23	13
24	14
25	15
26	16
27	17
28	18
29	19
30	20
31	21
32	22
33	23
34	24
35	25
36	26
37	27
38	28
39	29
40	30
41	31
42	32
43	33
44	34
45	35
46	36
47	37
48	38
49	39
50	40
51	41
52	42
53	43
54	44
55	45
56	46
57	47
58	48
59	49
60	50
61	51
62	52
Sheet1

Cell Formulas
Range	Formula
D11:D62	D11	=IF(C11="","",C11/$D$5*$D$6)

 

[RainerJonker]

No not that, at the moment the average at the bottom is 0,29% but that is when you divide the sum by 52. I want a way to keep the average tonly as you fill in new input values, so the average now with this data should show 2.9%

SRP Test 1.xlsx
	A	B	C	D	E
7
8			Shift A:
9
10		Weeks:	Input Values:	% Towards Total:
11		1	7000	5.70%
12		2	2000	1.63%
13		3	20	0.02%
14		4	2345	1.91%
15		5	7000	5.70%
16		6		0.00%
17		7		0.00%
18		8		0.00%
19		9		0.00%
20		10		0.00%
21		11		0.00%
22		12		0.00%
23		13		0.00%
24		14		0.00%
25		15		0.00%
26		16		0.00%
27		17		0.00%
28		18		0.00%
29		19		0.00%
30		20		0.00%
31		21		0.00%
32		22		0.00%
33		23		0.00%
34		24		0.00%
35		25		0.00%
36		26		0.00%
37		27		0.00%
38		28		0.00%
39		29		0.00%
40		30		0.00%
41		31		0.00%
42		32		0.00%
43		33		0.00%
44		34		0.00%
45		35		0.00%
46		36		0.00%
47		37		0.00%
48		38		0.00%
49		39		0.00%
50		40		0.00%
51		41		0.00%
52		42		0.00%
53		43		0.00%
54		44		0.00%
55		45		0.00%
56		46		0.00%
57		47		0.00%
58		48		0.00%
59		49		0.00%
60		50		0.00%
61		51		0.00%
62		52		0.00%
63
64		Average weight:		0.29%
65
Sheet3

Cell Formulas
Range	Formula
D11:D62	D11	=C11/$D$5*$D$6
D64	D64	=SUM((D11:D62)/52)

 

[JV0710]

In Cell D64 enter this formula: =AVERAGEIF(C11:C62,">0",D11:D62)

 

[RainerJonker]

Not all heroes wear capes, thank you very much!

 

[JV0710]

Welcome . . .