How to add 4 of 5 highest numbers using a formula

[jost]

How to make a formula for this problem in Excel

 

[Arvi Laanemets]

Hi

=SUM(A1:A5)-MIN(A1:A5)


Arvi Laanemets

 

[Bob Phillips]

or

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

--

HTH

RP
(remove nothere from the email address if mailing direct)