Forum Discussion

Simon0307's avatar
Simon0307
Copper Contributor
Sep 25, 2023
Solved

Excel - sum largest 5 numbers out of 6

I need to add the 5 largest numbers together from a list of 6. The 6 are not in a consecutive line and there are other numbers in between. The list are on the following rows: D7,D9,D11,D13,D15,D17 ...
Formulas and Functions
  • JosWoolley's avatar
    JosWoolley
    Sep 25, 2023

    Simon0307 

    =SUM(LARGE((D7,D9,D11,D13,D15,D17),{1;2;3;4;5}))

    or

    =LET(φ,(D7,D9,D11,D13,D15,D17),SUM(φ)-MIN(φ))

     

     

HansVogelaar's avatar
HansVogelaar
MVP
Sep 25, 2023

Simon0307 

for example:

 

=SUM(LARGE(IF(MOD(ROW(D7:D19),2),D7:D19),SEQUENCE(5)))

Resources