FILTER Function in Apple Numbers: Examples and Syntax
FILTER in Apple Numbers: create a live view of active inventory using practical sample data, clear expected results, pitfalls and the official function documentation.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked
Quick answer: Create a live view of active inventory. Keep the inventory master list untouched, but show only items whose stock is positive in a separate result area.
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
=FILTER(array, test-array, if-empty)
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: Product | B: Stock |
|---|---|---|
| 2 | Pads | 8 |
| 3 | Clips | 0 |
| 4 | Tape | 3 |
| 5 | Envelopes | 0 |
Enter this formula in a free result cell (outside the input range):
=FILTER(A2:B5,B2:B5>0,"Nothing in stock")
Expected result: Pads 8; Tape 3.
Why this result is correct: The Boolean test includes rows 2 and 4 and excludes rows 3 and 5. FILTER returns an array that can expand into multiple cells.
A second example or variation
=FILTER(A2:B5,B2:B5>10,"Nothing in stock")
Expected result: Nothing in stock.
The optional fallback avoids displaying an unhelpful error when nothing passes the test.
Common mistakes and troubleshooting
Leave enough empty output cells for spilled array results. Unlike a toolbar filter, the formula produces a new dynamic result area.
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
Keep the inventory master list untouched, but show only items whose stock is positive in a separate result area. 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
Think of FILTER as a derived view of existing table records, not an operation that deletes unwanted source rows. Make the inclusion condition explicit and inspect the output when no rows qualify.
Avoid relying on the order of records as a surrogate for an actual sort rule; use a deliberate sorting step if output order matters.
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 — FILTER 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.