Math & trig
SUM function
Sum of values. SUM works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=SUM(value1, [value2, ...]) | Argument | Use |
|---|---|
value1 | required, repeatable |
value2 | optional, repeatable |
| required |
Example
Add up every order amount.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Status | Amount | Date |
| 2 | #1001 | Acme Ltd | North | Paid | 1200 | 2026-01-14 |
| 3 | #1002 | Blue Fox | South | Open | 450 | 2026-01-20 |
| 4 | #1003 | Acme Ltd | North | Paid | 980 | 2026-02-03 |
| 5 | #1004 | Cedar & Co | East | Overdue | 2300 | 2026-02-11 |
| 6 | #1005 | Blue Fox | South | Paid | 610 | 2026-03-02 |
| 7 | #1006 | Delta BV | West | Open | 1750 | 2026-03-09 |
| 8 | 7,290 |
Result computed by the Sheets formula engine.
On live data
In Sheets, SUM sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
Try it in a free calculator
Percentage calculatorWork out a percent of a number, what percent one number is of another, and the percent change between two values, with the spreadsheet formula for each..Multiply columns and add them upMultiply quantity by price on each row, sum the column, and get the same total in one SUMPRODUCT formula.Profit margin calculatorCalculate gross profit margin and markup from cost and price, or the selling price for a target margin or markup, with the spreadsheet formula for each..
More math & trig functions
ROUNDRound to N decimalsSUMIFSum where one criterion matchesSUMIFSConditional sumSUMPRODUCTSum of element-wise productsABSAbsolute valueACOSArccosine, in radiansACOSHInverse hyperbolic cosineACOTArccotangent, in radiansACOTHInverse hyperbolic cotangentAGGREGATEAggregate that can skip error valuesARABICRoman numerals as a numberASINArcsine, in radians
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.