How to add 4 of 5 highest numbers using a formula
 

How to make a formula for this problem in Excel

Hi

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


Arvi Laanemets


"jost" wrote in message
...
How to make a formula for this problem in Excel

or

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

--

HTH

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


"Arvi Laanemets" wrote in message
...
Hi

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


Arvi Laanemets


"jost" wrote in message
...
How to make a formula for this problem in Excel