Totaling a column

rtrosper · 09/21/22

How can I get Smartsheet to total up the cells in a column that are not blank?

Andrée Starå · 09/21/22

Hi @rtrosper

I hope you're well and safe!

Not sure I follow! Can you elaborate?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SmartLew · 09/21/22

=COUNTIF({range you want to total},<>"")

<> means does not equal

"" means blank

Depending on whether you are referencing another sheet or the same sheet, your range will look different in the formula. Referencing a different sheet it will look like the above example, referencing the same sheet it will look like : [column name]:[column name]

SmartLew · 09/25/22

https://community.smartsheet.com/discussion/comment/344336#Comment_344336

@rtrosper did this work for you?

Totaling a column

Answers

Categories