sumifs dynamic range problem


Hi all,

I have a sheet with a summary section in the first lines.

The summary section has sumifs formulars with a range like "budget$55:budget159" which will work fine.

If a new line 160 is inserted by a form, the formular will not be expanded to "budget$55:budget160".

Trying to change the formula to an endless end like "budget$55:budget" will not work.

"budget:budget" is not possible because this formula is in the budget row => circular reference

Is there any way to solve this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!