AVERAGEIF Function in Apple Numbers: Syntax, Examples and Troubleshooting
A practical Apple Numbers AVERAGEIF guide with exact syntax, verified documentation, worked results and common pitfalls.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked
AVERAGEIF function in Apple Numbers
Quick answer: Use =AVERAGEIF(A2:A6,"East",B2:B6) to average amounts for one region, without including other regions.
Use this function when you need to average values only for rows that satisfy a condition. The data below are original tutorial examples; expected answers were independently reasoned from the supplied rows, not obtained by running Numbers.
Syntax and argument definitions
=AVERAGEIF(test-values, condition, avg-values)
| Argument | Apple Numbers meaning and requirements |
|---|---|
test-values |
Range whose entries are checked against the condition; may contain any value. |
condition |
Criterion such as "East", ">20", a cell reference or a documented wildcard/REGEX condition. |
avg-values |
Optional range to average; must align in size with test-values. If omitted, Numbers uses test-values. |
The placeholder names and ordering above follow Apple’s AVERAGEIF reference, checked 2026-10-10 America/Toronto (2026-10-11 UTC). Apple’s English examples use comma-separated arguments. If input parsing differs for your locale, use the in-app function browser to insert the function and select ranges instead of guessing separators.
Reproduce the worked example
In Numbers, create a new table named Example. Put the headings in row 1, add the following exact data in the corresponding row numbers, and enter the formula in an empty result cell outside the source ranges.
| Row | A: Region | B: Hours |
|---|---|---|
| 2 | East | 10 |
| 3 | West | 14 |
| 4 | East | 20 |
| 5 | West | 22 |
| 6 | East | 30 |
=AVERAGEIF(A2:A6,"East",B2:B6)
Expected output: 20.
How to check the result: The matching amounts are 10, 20 and 30; their sum 60 divided by three is 20.
More advanced scenario
With the same data table, enter:
=AVERAGEIF(B2:B6,">20")
Expected output: 26.
Omitting avg-values makes B2:B6 both the comparison and averaged range. Only 22 and 30 qualify, giving 26.
For formulas in a different table, let the Numbers formula editor insert the correct cross-table references; do not blindly paste Excel sheet syntax into a Numbers document.
Limitations, edge cases and errors
Apple requires test-values and avg-values to have equal dimensions. When avg-values is omitted, the test-values collection itself must contain only numbers or Booleans. Wildcards can match text, but use a plain quoted criterion for exact labels. No matching numeric observations means no sensible average; review the app’s error display before proposing fallback values.
Troubleshooting checklist
If the result seems incorrect, inspect accidental spaces in category labels, the condition quotes, source numeric types and whether the two ranges start and end on matching rows. For multiple criteria choose AVERAGEIFS and verify its different argument order.
If an input is absent or text where a numeric value is required, check the cell’s actual value type, not only its visual number format. Remove downstream error-handling wrappers temporarily when diagnosing a hidden calculation problem.
macOS, iPhone and iPad: version-aware notes
Apple documents these named functions in the shared Formulas and Functions Help, accessible when using Numbers and other iWork table editors. This source check confirms the syntax in the documentation available on the check date, not a specific minimum release version. The checked pages did not establish an introductory app version or a macOS-versus-iOS formula difference for this function; do not claim historical or device-specific parity without testing the actual installed versions. Entry workflow and localised punctuation may differ, so follow the platform’s Functions Browser if typing directly fails.
Excel, Google Sheets and LibreOffice Calc
AVERAGEIF is also present in Excel, Google Sheets and LibreOffice Calc, though table-reference syntax, locale separators and error reporting can differ. Do not substitute SUMIF: it computes a total rather than an average.
Related Apple Numbers guides
Official reference and verification
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.