Forum Discussion
FrankBisss
Aug 15, 2022Copper Contributor
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
OliverScheurich
Aug 15, 2022Gold Contributor
=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.