[ms office - 2007] Capped 8 Function

[tw15ns]

We have a spreadsheet with results from a termly review of our Key Stage 4 students. I have been asked if I can find the total of the eight best results for each student. Can anyone think of a function in Excel that will sum the eight highest results from a range of marks.

 

Thanks

[ChrisH]

Sounds like more of a job for VBA than a function.