SUM

Modified on Wed, 29 May at 10:46 PM

Introduction

Returns the sum of the given numeric column as a value in all cells.


FORMULASUM(numeric_col)
EXAMPLE FORMULASUM(sales_col)
EXAMPLE INPUT5, 10, 20, 23
EXAMPLE OUTPUT58


Sample Usage


Valid ExamplesInvalid 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article