adding formula

Occasional Visitor



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






1 Reply



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