Skip to content
Google Sheets

SUM function in Google Sheets

Returns the sum of a series of numbers and/or cells.

=SUM(value1, [value2, ...])

SUM syntax and parameters

Two arguments, one required.

  • value1anyRequired

    The first number or range to add together.

  • value2anyRepeating

    [ OPTIONAL ] - Additional numbers or ranges to add to value1.

SUM examples

Formulas you'll actually reuse.

  1. Total deal value for the whole orders sheet:

    =SUM(C2:C200)

    Result148200

  2. Revenue net of refunds — two ranges in one formula:

    =SUM(C2:C200) - SUM(D2:D200)

    Result141350

SUM in Excel

Same name — your formula ports as-is.

Try SUM in the playground

Edit the example — nothing to install.

Preloaded with the SUM formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.