Sum Entire Column Starting at Row 4
I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be
=SUM([ColumnA]4:[ColumnA])
but this gets an #Unparseable error.
How might I create a Sum excludes everything above Row 4 but includes everything below Row4?
Thanks
Jennie
Answers
-
hi @Jennie Hoffmann,
so when you choose a range for any formula you can choose specific rows or you choose entire column.
so instead of =SUM([ColumnA]4:[ColumnA])
you shall have something like =SUM([ColumnA]4:[ColumnA]20) - it's limited for rows from 4 to 20
or you can have =SUM([ColumnA]:[ColumnA]) so it takes entire column as a range and you can make those calculations in Sheet Summary.
Btw as ColumnA is only one word you do not need [] brackets those are only if you have name of the column as two words like Column A.
Hope this helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!