Sheet Summary Function - Column Sums

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.

Christian Graf

Hello @M Scrog

You can use the formula:

=SUM([column]:[column])

This gives you the sum of that column of data.

Hope this helps!

Laurie Olson

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.