SUM
In sheet summary, how do I sum up a column?
Best Answer
-
Hi @JenaW - You would use the SUM formula as you would anywhere in the sheet. You would create a Text/Number field in the Sheet summary and then add the formula. I have two examples.
For a column that is a single word:
=SUM(Column:Column)For a column that is multiple words:
=SUM([Column Name]:[Column Name])I hope that helps!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Answers
-
Hi @JenaW - You would use the SUM formula as you would anywhere in the sheet. You would create a Text/Number field in the Sheet summary and then add the formula. I have two examples.
For a column that is a single word:
=SUM(Column:Column)For a column that is multiple words:
=SUM([Column Name]:[Column Name])I hope that helps!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
Check out the Formula Handbook template!
