Forum Discussion

FrankBisss's avatar
FrankBisss
Copper Contributor
Aug 15, 2022

adding formula

Hi,

 

I have a row of 16 differents number

I want to addition  the 6 upper  number of the row with a formula.

What is the formula please

 

Thank's

 

Frank

 

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 15, 2022

    FrankBisss 

    =SUM(LARGE(A3:P3,{1,2,3,4,5,6}))

    You can try this formula for the data layout of the example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

     

Resources