SUMIF helps you sum amounts for rows matching one criterion. In Numbers, start a formula with an equals sign and use the function browser if you want to select reference cells rather than typing their addresses.

=SUMIF(test-values, condition, sum-values)

test-values is the region or category range to examine; condition is the criterion, such as "East"; sum-values is an optional corresponding numerical range to total. Matching ranges must align.

Numbers shows comma-separated arguments in its English documentation. For locales with a decimal comma, use semicolons as function argument separators. Enter references by selecting the correct cells or table columns.

Create a table named Sales with headers in row 1 and the following data in rows 2–6:

Enter the formula in a result cell in the same table:

=SUMIF(A2:A6,"East",B2:B6)

Expected result: 245. East occurs in rows 2, 4 and 6; corresponding amounts 120 + 90 + 35 = 245.

=SUMIF(A2:A6,"West",B2:B6)

Expected result: 190. You can put the criterion in a separate cell instead of editing a formula every time; for example replace the quoted category with a selected criterion cell reference.

An exact category condition is different from a wildcard condition. Use "East" for just that category; Numbers also permits wildcard criteria in functions that accept conditions.

If SUMIF produces zero, verify the category spelling, the tested column and corresponding amount rows. Make sure criteria strings are quoted and test-values and sum-values cover the same number of rows.

A common source of confusion is referencing a different table: Numbers table names can appear in a reference, so use the editor to select the actual source range.

Excel and LibreOffice Calc also support SUMIF, but the optional sum range and range separators may vary by locale. For multiple criteria use SUMIFS; its argument order is different.

• COUNTIF in Apple Numbers
• COUNTIFS in Apple Numbers
• SUMIFS in Apple Numbers

• Apple Numbers — function documentation
• Formulas and Functions Help
• function index
• syntax guidance

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.