How to calculate sum of best of five out of six external marks

[newmake]

we have six subject marks internal and external
need formula to sum best of five subject external marks and sum of internal marks which correlate with best of five external marks

External Marks
ENGLISH HINDI MATHEMATICS SCIENCE SOCIAL SCIENCE COMPUTER SCIENCE (Internal marks )ENGLISH HINDI MATHEMATICS SCIENCE SOCIAL SCIENCE COMPUTER SCIENCE
55.0 25.0 66.0 78.0 49.0 17.0 15.0 12.0 16.8 18.7 17.5 15.5

Result we need
78.0 66.0 55.0 49.0 25.0 273.0
18.7 16.8 15.0 17.5 12.0 80.0

Bestfive.jpg

[JohnTopley]

Duplicate thread:

https://www.excelforum.com/excel-gen...d-formula.html


AND no file attached as requested in your first thread.

[newmake]

Remove first file attached
How to attaché file

[Sam Capricci]

if you are asking how to attach a file you use the "go advanced" button below the reply window and midway down the screen you'll see manage attachment, you click on that, hint, it is usually quickest and easiest to put the file on your desktop so you can go there when browsing for it.

[dominicb]

newmake

Please continue in your original post.

https://www.excelforum.com/excel-gen...d-formula.html

Change the title if requested by a moderator - don't just start a new thread. And add a file if you're asked to. A screen capture is no good. No one is going to spend their free time to recreate a sample if you can't be bothered to.

Thread closed.

DominicB