Math & trig

SUMIF function

Sum where one criterion matches. SUMIF works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=SUMIF(range, criterion, [sum_range])
ArgumentUse
rangerequired
criterionrequired
sum_rangeoptional

Example

Total only the paid orders.

fx=SUMIF(D2:D7, "Paid", E2:E7)
ABCDEF
1OrderCustomerRegionStatusAmountDate
2#1001Acme LtdNorthPaid12002026-01-14
3#1002Blue FoxSouthOpen4502026-01-20
4#1003Acme LtdNorthPaid9802026-02-03
5#1004Cedar & CoEastOverdue23002026-02-11
6#1005Blue FoxSouthPaid6102026-03-02
7#1006Delta BVWestOpen17502026-03-09
82,790

Result computed by the Sheets formula engine.

On live data

In Sheets, SUMIF 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.

See the integrations

Try it in a free calculator

Multiply columns and add them upMultiply quantity by price on each row, sum the column, and get the same total in one SUMPRODUCT formula.

More math & trig functions

ROUNDRound to N decimalsSUMSum of valuesSUMIFSConditional 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

All 84 math & trig functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations