formula for aggregate using WPS spreadsheet 2020

[jentyl]

In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel has to select Six Subjects from ine Subjects, with Four being compulsory and Two other best I want an excel formular that will add the grade value of four compulsory subjects : English, Maths, Science, Social. And then automatically select 2 other subjects from the rest with best value.

 

[awoohaw]

Do you want the average of these or the SUM of these?
And to clarify your question, You want the AVERAGE (or SUM) of 4 fixed values plus the highest 2 scores of the other values?

 

[Fluff]

Hi & welcome to MrExcel.

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[jentyl]

Hi & welcome to MrExcel.

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I'm using WPS spreadsheet 2020

 

[jentyl]

Do you want the average of these or the SUM of these?
And to clarify your question, You want the AVERAGE (or SUM) of 4 fixed values plus the highest 2 scores of the other values?

SUM of 4 fixed values(D5,F5,H5,J5) plus the highest 2 scores of the other values

 

[Fluff]

I'm using WPS spreadsheet 2020

In future please make it clear what you are using if not Excel & such questions should be posted in the General Discussion & Other Applications section of the board.
I have done that for you this time.

 

[awoohaw]

maybe this now:

Book1
	C	D		F		H		J	K	L	M	N	O	P	Q	R	S	T
1		SUM of 4 fixed values(D5,F5,H5,J5) plus the highest 2 scores of the other values
2
3	61	2		3		4		5	18	3	4	1	10	7	13	8	17	2
4
Sheet1

Cell Formulas
Range	Formula
C3	C3	=SUM(LARGE($K$3:$T$3,1),LARGE($K$3:$T$3,2),K3,L3,M3,N3)