Excel functions

  Newuser3477 20:05 08 May 2007
Locked

I want to sum the three highest values of and in four cells.
Any help gratefully received
Peter

  daba 23:07 08 May 2007

sum all of them and subtract the smallest

say your values are in A1 to A4

your answer in another cell =SUM(A1:A4)-MIN(A1:A4)

  Newuser3477 23:32 08 May 2007

Thanks daba

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?