I want to calculate the aggregate from 9 sheets to appear on my summary sheet based on the criterior you gave me earlier. 4 compulsory + 2 best subjec

[peterappiahkubi]

		SUMMARY
S/N	NAME	TOTAL SCORE	AVERAGE	POSITION	POSITION	AGGREGATE
1	ACQUAH EMMANUEL	615.0	68.3		1ST	#VALUE!
2	AKUFFO DERRICK	0.0	0.0		2ND	#VALUE!
3	DON-GAGLA BENEDICT	0.0	0.0		2ND	#VALUE!
4	NYAME A. BLESSING	0.0	0.0		2ND	#VALUE!
5	SEKYERE JOSEPH	0.0	0.0		2ND	#VALUE!
6	YAHAYA ISSAH	0.0	0.0		2ND	#VALUE!
7	AIDOO AGNES	0.0	0.0		2ND	#VALUE!
8	ANTWI AMOANIMAAH LOIS	0.0	0.0		2ND	#VALUE!
9	ARHIN ELIZABETH	0.0	0.0		2ND	#VALUE!
10	BOAKYE BERNICE	0.0	0.0		2ND	#VALUE!
11	FORIWAA HAPPY OBENG	0.0	0.0		2ND	#VALUE!
12	FORSON LYDIA	0.0	0.0		2ND	#VALUE!
13	MANU OPARE KEZIAH	0.0	0.0		2ND	#VALUE!
14	SAMARI DORCAS	0.0	0.0		2ND	#VALUE!
15	TORKPO PRORCHIA EMEFA	0.0	0.0		2ND	#VALUE!
16		0.0	0.0		2ND	#VALUE!
17		0.0	0.0		2ND	#VALUE!
18		0.0	0.0		2ND	#VALUE!
19		0.0	0.0		2ND	#VALUE!
20		0.0	0.0		2ND	#VALUE!
21		0.0	0.0		2ND	#VALUE!
22		0.0	0.0		2ND	#VALUE!
23		0.0	0.0		2ND	#VALUE!
24		0.0	0.0		2ND	#VALUE!
25		0.0	0.0		2ND	#VALUE!
26		0.0	0.0		2ND	#VALUE!
27		0.0	0.0		2ND	#VALUE!
28		0.0	0.0		2ND	#VALUE!
29		0.0	0.0		2ND	#VALUE!
30		0.0	0.0		2ND	#VALUE!
31		0.0	0.0		2ND	#VALUE!
32		0.0	0.0		2ND	#VALUE!
33		0.0	0.0		2ND	#VALUE!
34		0.0	0.0		2ND	#VALUE!
35		0.0	0.0		2ND	#VALUE!
36		0.0	0.0		2ND	#VALUE!
37		0.0	0.0		2ND	#VALUE!
38		0.0	0.0		2ND	#VALUE!
39		0.0	0.0		2ND	#VALUE!
40		0.0	0.0		2ND	#VALUE!
41		0.0	0.0		2ND	#VALUE!
42		0.0	0.0		2ND	#VALUE!
43		0.0	0.0		2ND	#VALUE!
44		0.0	0.0		2ND	#VALUE!
45		0.0	0.0		2ND	#VALUE!
46		0.0	0.0		2ND	#VALUE!
47		0.0	0.0		2ND	#VALUE!
48		0.0	0.0		2ND	#VALUE!
49		0.0	0.0		2ND	#VALUE!
50		0.0	0.0		2ND	#VALUE!

 

[Fluff]

Duplicate to: AGGREGATE ON MASTER SHEET

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.