Need help on Auto calculating aggreggates

[KOOLMAN]

Please, I made a simple template to take grades of my pupils. In the templates, some subjects on a continuum are compulsory (H - K) while the remaining (L- P) are optional, but 2 of them (best 2 with good grades ) to be added to H-K to give the aggregate in Q as indicated in the table below.

	....	H	I	J	K	L	M	N	O	P	Q
1		ENGLISH LANG	MATHS	SCIENCE	SOCIAL	LANG	TECH	MORAL STUDIES	ICT	FRENCH	AGGREGATE
2	KOOL	2	3	5	1	6	5	1	2	1	13
3	SUUTY	3	1	4	3	8	2	4	3	5	15
4	BASH	2	3	2	1	2	1	2	1	1	10

<tbody>
</tbody>

How do I pick N2 and P2 (for KOOL), M3 and O3 (for SUUTY) , O4 and P4 add it automatically to the range H2:K2 without manually editing the formular by picking N2 and P2?

Thanks so much in advance.

 

[baitmaster]

welcome to the board

Try =SUM(H2:K2)+SMALL(L2:P2,1)+SMALL(L2:P2,2)

 

[KOOLMAN]

Tried but it returns #Value !. Thank you. Any other possible way?

 

[baitmaster]

No, you need to investigate why it's returning an error because it shouldn't

Do any of your input cells contain # value! errors?

Do any of your inputs contain numbers formatted as text, or that are otherwise blank, maybe including spaces? [unlikely to be this. Errors here would cause # Num! errors]

In the formula bar, highlight each section in turn and hit F9 to calculate that part of the formula. Which part creates the error?
- SUM(H2:K2)
- SMALL(L2:P2,1)
- SMALL(L2:P2,2)

 

[KOOLMAN]

It worked! God bless you. At first I didn't close one of the brackets. I'm happy!

 

[KOOLMAN]

Thank you. I just investigated that and it worked.