Sheet Summary Function - Column Sums
Options
M Scrog
✭✭✭
I am attempting to enter a sheet summary formula to sum a column. My end goal is to build a report that I can then filter the results of that column summary by other data points in the sheet.
Any help is appreciated.
Answers
-
Hello @M Scrog
You can use the formula:
=SUM([column]:[column])
This gives you the sum of that column of data.
Hope this helps!
-
The problem with this formula in the summary column is that if you instead use AVG, Smartsheet seems to pad 10 rows give or take to the sheet. Then it uses those empty rows in the calculation.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!