xl sreadsheet formula reqd

  widdy 09:34 23 Jun 03

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

  VoG® 09:49 23 Jun 03

With the scores in A1:A7

=SUM(LARGE(A1:A7,1), LARGE(A1:A7,2),LARGE(A1:A7,3), LARGE(A1:A7,4))

  widdy 10:00 23 Jun 03

Thanks a million
works a treat

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

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…