Sort and Filter Numbers Tables by Multiple Conditions

Quick answer: Select the table, click Organize in the toolbar, then open the Filter tab in the Organize sidebar. Add conditions for the required columns, then choose whether rows must match all filters or any filter. For a checkbox column, a Quick Filter lets you keep the checked value. An unchecked checkbox is false, not an unanswered third state. Apple’s filter guide and cell-controls guide describe the underlying features.

Scope and what filtering changes

This walkthrough uses Numbers for Mac and the 15.4 user guide, checked October 15, 2026. Find your version under Numbers → About Numbers. The menu and sidebar instructions are Mac-specific; do not apply them unchanged to iPad, iPhone, or Numbers for iCloud. See the current Mac guide.

Filtering chooses which rows are visible in a particular table. Sorting changes row order. Neither operation should be treated as a way to remove private information before sending the spreadsheet: hidden records still belong to the file. Keep an unmodified practice copy while learning.

Create a reproducible order table

Use one header row and columns A:G in a table named Orders. Download the synthetic order CSV, or enter this sample. Empty Notes cells are genuinely empty. The CSV contains TRUE and FALSE values for Reviewed, but it does not store Numbers checkbox formatting.

Select F2:F9, click Format in the toolbar, then open the Cell tab in the Format sidebar. Choose Checkbox from Data Format. Explicitly check the boxes for orders 1001, 1002, 1005, and 1007, and clear the other four. This makes the initial state reproducible even if imported Boolean text was interpreted differently by your version or locale. Leave F1 as the Reviewed header. The toolbar button opens the sidebar if needed; it is separate from the Format menu in the menu bar. Apple explains the sidebar controls.

Before filtering, verify eight order records and four checked boxes. The total of the Amount column is 910. Do not use that full-column total as proof that only visible rows are being totaled after filtering; row visibility and formula inclusion are separate questions.

Example 1: reviewed East orders worth at least 100

The business rule is:

Region = East AND Amount ≥ 100 AND Reviewed is checked.

1. Open the arrow beside column F and choose Quick Filter. Keep the value corresponding to the selected checkbox and hide the unselected value. Click outside the list when finished.
2. Click Organize in the toolbar, then open the Filter tab in the Organize sidebar. The Quick Filter is also listed there.
3. Use Add a Filter for Region and make an exact text-match rule for East.
4. Add a filter for Amount, using a numeric rule of greater than or equal to 100. Enter the number 100, without explanatory text.
5. Set the combination control at the top to all filters.
6. Check the order IDs, not just the number of visible rows.

The expected visible records are 1001 and 1007, with amounts 120 and 200. Their independently calculated total is 320.

Order 1003 is East and worth 160, but it is not reviewed. Order 1005 is reviewed and worth 140, but it is West. Those two rows are useful negative controls: if either appears, one condition is missing or the combination is wrong.

The checkboxes inside the Quick Filter list select which values to display. They are not the same thing as the Reviewed checkboxes inside your table. Filtering for checked rows should not mark unchecked records reviewed.

Example 2: understand “any” before using it

Keep the same three conditions and change the combination to any. Now a row passes if it is East, or worth at least 100, or reviewed. It need not meet the other two conditions.

The expected IDs are 1001, 1002, 1003, 1005, 1007, and 1008. Their amounts total 745. North orders 1004 and 1006 fail all three tests and remain hidden.

Order 1008 demonstrates the difference especially clearly: its amount is only 40 and it is unreviewed, but its East region is enough for any. Switch back to all when the requirement is “reviewed East orders worth at least 100.”

This is a good way to diagnose “the filter shows too many rows”: translate the rule into a sentence, then test one row that satisfies only a single condition.

Add a blank-notes condition

Return to the all setup. Add a Quick Filter for Notes that keeps the empty value shown in that column’s value list. Check that this new filter participates in the same all combination.

Only 1007 should remain: it is East, worth 200, reviewed, and has no note. Order 1001 fails the last condition because its note is Urgent.

Use this deliberately blank sample before applying the rule to imported data. A cell containing spaces or the literal text N/A is not the same thing as a truly empty cell. A formula that displays an empty string is another case worth testing in the actual file; this example uses no formula-generated blanks.

If “not reviewed yet” needs to differ from “reviewed and rejected,” a single checkbox is the wrong data model. Apple documents only selected/true and unselected/false checkbox values. Use a separate explicit status field with choices such as Pending, Approved, and Rejected, rather than expecting a checkbox to retain a third state.

Mixed logic: East or West, but still reviewed and at least 100

A single global all/any setting does not express every parenthesized condition. For this rule:

(East OR West) AND Amount ≥ 100 AND Reviewed

add a helper column H, named Include. Turn off the existing filters while preparing it. In H2 enter:

=AND(OR(B2="East",B2="West"),D2>=100,F2)

Fill the formula down to H9. The row references must change with each row. In a locale using semicolons as formula separators, use the syntax Numbers expects locally. Filter Include to its true value using Quick Filter, and remove or disable the earlier Region/Amount/Reviewed/Notes filters so they do not narrow the result again.

The expected IDs are 1001, 1005, and 1007, totaling 460. The helper makes the grouping explicit and is easier to inspect than a stack of rules whose meaning is unclear. See AND and OR for the formula logic; Apple’s AND reference and OR reference document the Boolean tests.

Sort the matches without splitting the records

Turn off all filters to restore the eight original records before this sorting exercise. Select Orders, click Organize in the toolbar, then open the Sort tab in the Organize sidebar. Choose Sort Entire Table, add Region ascending as the first rule and Amount descending as the second, then apply Sort Now. Rule priority matters: this groups regions first and ranks amounts within each region. Apple documents multi-column sorting.

Expected order IDs are:

1007, 1003, 1001, 1008, 1004, 1006, 1005, 1002.

Keep the entire record together. Do not copy and sort only the displayed amounts into another location and then assume they still match the original order IDs. A stable Order column makes mistakes easier to detect.

Recovery and edge cases

• No rows appear: Turn filters off, confirm the sample values, then re-enable one condition at a time. Check numeric amounts are numbers and Region text matches your intended labels.
• Old rules still affect a new experiment: Quick Filters appear alongside other filters. Inspect the complete rule list, not just the most recently opened column menu.
• Filter or sort controls are unavailable: Check for merged cells. Apple documents merged-cell restrictions; unmerge only after considering the layout and preserving a copy.
• Adding rows while filtered: Apple says new cells are populated to satisfy the existing filter rules. Turn filters off before a neutral data-entry/import session, then inspect the new record before restoring the view. Do not mistake filter-supplied values for an answer somebody entered.
• Need to restore everything: Turn off the table’s Filters checkbox. This keeps the rules available for reuse instead of deleting them.
• Need a visible-only summary: Define that separately. For example, COUNTIF can count true values in a helper range without depending on which rows happen to be visible.

Verification and sources

Expected row sets, totals, and sort order were calculated independently against the sample. The Mac controls are documentation-based. This tutorial was not tested in Apple Numbers, and no application screenshots were captured. The exact checkbox/blank labels displayed by Quick Filter have not been verified. Apple documentation was checked on October 15–16, 2026.

• Filter data
• Add controls to cells
• Alphabetize or sort table data