How to calculate the percentage?

[nskatoch]

Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%age
Maximum Marks:		80	80	70	80	70	80	50	60
1	Albert	50	60		40	35	50	40		275
2	Browny	50			40	35			50	270
3	Cathe	70	50		40	35	50		45	290
4	Bill	60		60	40	35	50	35		280
5	Elora
6	Johan
7	Gimmi
8	Happy

In the above table the Maximum Marks of each subject are different. Each student opted different subjects and secured marks. I have used the formula for Total is as follows:
=IFERROR(SUM(C6,LARGE(D6:J6, 1), LARGE(D6:J6, 2), LARGE(D6:J6, 3), LARGE(D6:J6, 4), LARGE(D6:J6, 5)),"")
Now please suggest me that what formula use for percentage for each student?

 

[sharshra]

Does this work?

Book1
	C	D	E	F	G	H	I	J	K	L	M	N
3	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%
4	Maximum Marks:		80	80	70	80	70	80	50	60	570
5	1	Albert	50	60		40	35	50	40		275	62,5%
6	2	Browny	50			40	35			50	175	60,3%
7	3	Cathe	70	50		40	35	50		45	290	64,4%
8	4	Bill	60		60	40	35	50	35		280	65,1%
9	5	Elora
10	6	Johan
11	7	Gimmi
12	8	Happy
Sheet2

Cell Formulas
Range	Formula
M4:M8	M4	=SUM(E4:L4)
N5:N8	N5	=SUM($E5:$L5)/SUMIF($E5:$L5,">0",$E$4:$L$4)

 

[awoohaw]

Do you want the average of the averages? Or do you want the average of percentage for each class?

Try this:

(Also, i could not get consisent result with your total formula, please review)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%age	Your Total???
2	Maximum Marks:		80	80	70	80	70	80	50	60
3	1	Albert	50	60		40	35	50	40		275		275	63%
4	2	Browny	50			40	35			50	270			61%
5	3	Cathe	70	50		40	35	50		45	290		290	65%
6	4	Bill	60		60	40	35	50	35		280		280	66%
7	5	Elora
8	6	Johan
9	7	Gimmi
10	8	Happy
Sheet2

Cell Formulas
Range	Formula
M3:M10	M3	=IFERROR(SUM(C3,LARGE(D3:J3, 1), LARGE(D3:J3, 2), LARGE(D3:J3, 3), LARGE(D3:J3, 4), LARGE(D3:J3, 5)),"")
N3:N10	N3	=IFERROR(AVERAGE(FILTER(C3:J3/$C$2:$J$2,(C3:J3>0))),"")

 

[nskatoch]

Do you want the average of the averages? Or do you want the average of percentage for each class?

Try this:

(Also, i could not get consisent result with your total formula, please review)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%age	Your Total???
2	Maximum Marks:		80	80	70	80	70	80	50	60
3	1	Albert	50	60		40	35	50	40		275		275	63%
4	2	Browny	50			40	35			50	270			61%
5	3	Cathe	70	50		40	35	50		45	290		290	65%
6	4	Bill	60		60	40	35	50	35		280		280	66%
7	5	Elora
8	6	Johan
9	7	Gimmi
10	8	Happy
Sheet2

Cell Formulas
Range	Formula
M3:M10	M3	=IFERROR(SUM(C3,LARGE(D3:J3, 1), LARGE(D3:J3, 2), LARGE(D3:J3, 3), LARGE(D3:J3, 4), LARGE(D3:J3, 5)),"")
N3:N10	N3	=IFERROR(AVERAGE(FILTER(C3:J3/$C$2:$J$2,(C3:J3>0))),"")

Thanks for your response.
In this class, there are eight subjects. Some students opted eight subjects, some are seven or six. I want sum of larger value of five subjects+Marks of English subject. So, I have used this sum formula. Now How can I obtain percentage of each student (i.e. each row)?

 

[nskatoch]

Does this work?

Book1
	C	D	E	F	G	H	I	J	K	L	M	N
3	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%
4	Maximum Marks:		80	80	70	80	70	80	50	60	570
5	1	Albert	50	60		40	35	50	40		275	62,5%
6	2	Browny	50			40	35			50	175	60,3%
7	3	Cathe	70	50		40	35	50		45	290	64,4%
8	4	Bill	60		60	40	35	50	35		280	65,1%
9	5	Elora
10	6	Johan
11	7	Gimmi
12	8	Happy
Sheet2

Cell Formulas
Range	Formula
M4:M8	M4	=SUM(E4:L4)
N5:N8	N5	=SUM($E5:$L5)/SUMIF($E5:$L5,">0",$E$4:$L$4)

Thanks for your response.
The formula suggested by you works if SUM(E4:L4), but if the formula of TOTAL column is
=IFERROR(SUM(E4,LARGE(F4:L4, 1), LARGE(F4:L4, 2), LARGE(F4:L4, 3), LARGE(F4:L4, 4), LARGE(F4:L4, 5)),"") then it not works.
I want PERCENTAGE, Total marks obtained by above formula/sum of Max. Marks of those subjects from where above total obtained.
So, please suggest me.

 

[Phuoc]

What is your expected result in the yellow range?

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%age	Your Total???
2	Maximum Marks:		80	80	70	80	70	80	50	60
3	1	Albert	60	60	60	60	60	60	50	60	275		360	?
4	2	Browny	50	70	70	50	50	50	50	50	270		340	?
5	3	Cathe	50	50		50	50				290			?
6	4	Bill	60	35	60	40	35	50	35	35	280		280	?
Sheet1

Cell Formulas
Range	Formula
M3:M6	M3	=IFERROR(SUM(C3,LARGE(D3:J3, {1,2,3,4,5})),"")

 

[Burrgogi]

Do you want the average of the averages? Or do you want the average of percentage for each class?

He is not interested in the average. He's looking for the overall percentage grade (or score) for each student. Take Cathe in row 5 as an example. She took 4 classes and got 50 for each of the 4 classes resulting in total score of 200. (Total possible score for those 4 classes she took is 310).

200/310 = 64.5%

The OP is interested in the percentage score 64.5%

What is your expected result in the yellow range?

Why are you so worried about that yellow part? That was never in the original poster's question at the beginning nor did he ever mention it in his posting.

 

[Phuoc]

(Total possible score for those 4 classes she took is 310).

200/310 = 64.5%

The OP is interested in the percentage score 64.5%

If the 5th, 6th, 7th, and 8th highest marks are the same, which subject marks will be calculated?

Can you calculate the results of rows 3, 4 and 6?

 

[nskatoch]

What is your expected result in the yellow range?

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Roll No.	NAME OF STUDENT	ENGLISH CORE	HINDI CORE	COMPUTER SCIENCE	HISTORY	GEOGRAPHY	ECONOMICS	PHYSICAL ACTIVITY TRAINER	TOURISM	Total	%age	Your Total???
2	Maximum Marks:		80	80	70	80	70	80	50	60
3	1	Albert	60	60	60	60	60	60	50	60	275		360	?
4	2	Browny	50	70	70	50	50	50	50	50	270		340	?
5	3	Cathe	50	50		50	50				290			?
6	4	Bill	60	35	60	40	35	50	35	35	280		280	?
Sheet1

Cell Formulas
Range	Formula
M3:M6	M3	=IFERROR(SUM(C3,LARGE(D3:J3, {1,2,3,4,5})),"")

Thanks for your response.
In the above table, every student must opted minimum six subjects. Any student can obtain same marks in different subjects. I want output in N column is: The result of "TOTAL" column (M3=IFERROR(SUM(C3,LARGE(D3:J3,{1,2,3,4,5})),"") divided by the sum of Maximum marks of their coresponding subjects. So please suggest me the formula.

 

[Phuoc]

In case the marks large 5,6,7,8 are the same (rows 3,4,6), which subject do you choose?

What are the expected results of rows 3, 4 and 6?