adding formula

Occasional Visitor

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

 

1 Reply

@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.

sum top 6.JPG