Excel functions

  Newuser3477 20:05 08 May 07
Locked

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

  daba 23:07 08 May 07

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 07

Thanks daba

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

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

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced