Formula To Sum Four Highest Numbers In A Range

  • Thread starter Thread starter GTO
  • Start date Start date
G

GTO

Is it possible to write a formula to sum the four highest
numbers in a range. Example: In row 1 I have
88,83,82,82,78,82,84,84,78. I need a formula that will add
just the four highest numbers. Then I will copy it to
other rows to do same thing.

Thanks,
 
=SUM(LARGE(A1:I1,{1,2,3,4}))

Just change the range to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top