xl sreadsheet formula reqd

  widdy 09:34 23 Jun 2003
Locked

I require a formula for use in a scoring results type spreadsheet that will total the top four marks out of seven.
discarding the lowest and taking into account any scores that may be equal

e.g. s1 s2 s3 s4 s5 s6 s7 = Total
5 4 3 3 7 0 0 = 19

i.e either of s3 or s4 has been dropped and one included

Thanks in anticipation

  widdy 10:00 23 Jun 2003

Thanks a million
works a treat

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei MateBook X Pro (2019) review

Inside the redesign of the world's largest computer games platform, Steam

Apple Streaming Service Release Date & Apple TV Subscription Rumours

Quel antivirus gratuit choisir pour un PC ?