Introduction
Returns the sum of the given numeric column as a value in all cells.
| FORMULA | SUM(numeric_col) |
| EXAMPLE FORMULA | SUM(sales_col) |
| EXAMPLE INPUT | 5, 10, 20, 23 |
| EXAMPLE OUTPUT | 58 |
Sample Usage
| Valid Examples | Invalid Examples |
| SUM(Monthly Units, Monthly Total Gross Sales) | SUM(text_col) |
| SUM(date_col) |
Notes
- SUM can be used to find the sum of multiple columns
- Date and Text columns cannot be used with SUM
See Also
SUMBY
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article