SUMIFS Function in Apple Numbers: Examples and Syntax
SUMIFS in Apple Numbers: calculate revenue from one channel in one region using practical sample data, clear expected results, pitfalls and the official function documentation.
Reference checked: Examples have not been run in this spreadsheet application. How we verify guides
Quick answer: Calculate revenue from one channel in one region. You have orders from store and online channels. This formula gives North-region online revenue without including South orders or store sales.
This page covers the Apple Numbers implementation specifically. Its example values and expected results are original educational data, not screenshots or claims of a live application test.
Syntax and argument order
=SUMIFS(sum-values, test-values, condition, test-values…, condition…)
The argument order above follows the official Apple Numbers documentation. Use the function name shown here, and replace placeholder arguments with ranges, cell references or criteria from your workbook.
Worked example with sample data
| Row | A: Region | B: Channel | C: Revenue |
|---|---|---|---|
| 2 | North | Online | 100 |
| 3 | North | Store | 200 |
| 4 | South | Online | 300 |
| 5 | North | Online | 80 |
| 6 | South | Store | 40 |
Enter this formula in a free result cell (outside the input range):
=SUMIFS(C2:C6,A2:A6,"North",B2:B6,"Online")
Expected result: 180.
Why this result is correct: The first and fourth records contribute 100 and 80. The sum range must precede the condition/range pairs, which keeps the function distinct from COUNTIFS.
A second example or variation
=SUMIFS(C2:C6,A2:A6,"South")
Expected result: 340.
Removing the channel criterion adds both South orders: 300 + 40.
Common mistakes and troubleshooting
Imported text-formatted amounts will not behave like numeric amounts. Confirm numeric formatting, criteria spelling, and table references.
Also check that the version of Apple Numbers you use supports this function. A formula pasted from another application can fail because of different syntax, date interpretation, array behavior or regional separators. If the result differs, first compare the small dataset above with the expected answer before substituting your real data.
Where this function helps
You have orders from store and online channels. This formula gives North-region online revenue without including South orders or store sales. Replacing the sample cells with your own ranges lets you reuse the same reasoning. On important spreadsheets, test with a few known rows, verify the final cell formatting and keep a separate copy of the source data.
Practical checks before reusing this formula
Confirm that the values you want to total, rather than a category or quantity label, are in the sum range. Table-aware references make this particularly important when columns get moved.
For summaries that will be shared, keep a small hand-counted example alongside the production formula to document what qualified.
To compare this function with other spreadsheet programs, use our eight-software function comparison. A missing guide does not mean a function is unsupported in another product; check its official documentation.
Official reference and verification
- Official Apple Numbers — SUMIFS reference
- Verification status: Official documentation checked; example outcome 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.