Skip to content
Excel

SUM function in Excel

Adds its arguments

=SUM(number1, [number2], ...)

SUM syntax and parameters

Two arguments, one required.

  • number1numberRequired

    The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8.

  • number2numberRepeating

    This is the second number you want to add. You can specify up to 255 numbers in this way.

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 Google Sheets

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 Excel gets this done.