Sum range from @row to some number of rows below @row

Keita

Trying to find a solution to set the range of the sum expression from @row to some number of rows below @row.

Something along the lines of =SUM([Column]@row:[Column]@row+5).

NicoLHC

@Keita what you want achieve ? Do you have a screen shot

Keita

@NicoLHC

I want to have Column3 display the sum of all the descendants below @row even after a new entry. I can use =SUM([Column2]@row:[Column2]5), but I don't want to have update the expression once I add another row below row 5.

Andrée Starå

https://community.smartsheet.com/discussion/130859/sum-range-from-row-to-some-number-of-rows-below-row

Hi,

I hope you're well and safe!

Try something like this.

1. Add an auto number column and name it Auto.
   
2. Add another column, name it Row, add the following formula, and make it a column formula.
   =MATCH(Auto@row, Auto:Auto, 0)
   
3. Then, in Column3, add the following formula and make it a column formula.
   =SUMIFS([Column2]:[Column2], Row:Row, >=Row@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

NicoLHC

@Keita maybe also this simple way works ? =SUM(CHILDREN([column2]@row))