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
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!