Sum extending range
I need a formula that increases the sum range as more data is filled in. The formula must be part of the column, at the top and add data as it appears at the bottom.
Best Answer

Hi @Gladys Liley ,
The best way to do this is to sum the entire column. Are there values in rows 1 and 2 in that column that you don't want included? If not, you can just make your formula:
=SUM([Saturday Total]:[Saturday Total])
This will sum all numerical values within the column.
Hope this helps! Let me know if this works for you.
Best,
Heather
Answers

Hi @Gladys Liley ,
The best way to do this is to sum the entire column. Are there values in rows 1 and 2 in that column that you don't want included? If not, you can just make your formula:
=SUM([Saturday Total]:[Saturday Total])
This will sum all numerical values within the column.
Hope this helps! Let me know if this works for you.
Best,
Heather

That worked perfectly! I'll update all the formulas accordingly. Thank you!!

@Gladys Liley Fantastic! Glad it worked for you. Have a great day.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!