AVERAGEA Function in Apple Numbers: Syntax, Examples and Troubleshooting

Use AVERAGEA when you deliberately want nonnumeric observations to affect the denominator—for example, a row of true/false survey responses where TRUE should count as one and FALSE as zero. Use AVERAGE, not AVERAGEA, if descriptive text must be ignored rather than counted as zero. This distinction can materially change a reported average. [A1]

=AVERAGEA(value, value…)

• value (required): a value or collection of values such as a cell range. Apple describes it broadly as accepting any value. Within referenced cells, strings count as zero; Boolean FALSE counts as zero and TRUE as one.
• Additional value arguments (optional): further values or collections. No default numeric value is supplied for omitted additional arguments.
• Data-type restriction: Apple says date/time and duration values cannot be mixed with other value types; if dates or durations are present, the input values must all be of the same type. Do not assume that combining elapsed durations and dates calculates a meaningful average. [A1]

Names are case-insensitive when typed, but this article uses Apple’s uppercase spelling. The comma-separated examples follow the English help. If your spreadsheet uses the comma as the decimal separator, Apple instructs you to use semicolons between function arguments; for example, =AVERAGEA(B2:E2;G2) instead of =AVERAGEA(B2:E2,G2). The colon within B2:E2 denotes a range; it is not an argument separator. [L1]

Scope: Verified against Apple’s public Formulas and Functions Help 15.4, accessed 2026-10-12. It documents the formula semantics but does not, by itself, establish this function’s first supported release on every Mac, iPad, iPhone, or iCloud version. Native application execution and localized rendering have not been performed.

Make one table named Scores with headers in row 1: B = Test 1, C = Test 2, D = Test 3, E = Test 4. Enter the following values, preserving text as text and Boolean values as Boolean values:

Why those answers? Row 2 sums as 4 + 0 + 6 + 0 = 10 and divides by four values. Row 3 sums 5 + 0 + 1 + 10 = 16 and divides by four. Row 4 sums 0 + 0 + 0 + 1 = 1, also divided by four. These are expected, documentation-checked outputs, matching Apple’s examples with the range relocated within the same table; they are not observed Numbers results. [A1]

Compare this second formula in the same table:

=AVERAGE(B2:E2)

Expected result: 5 because AVERAGE ignores the referenced text, then divides (4 + 6) by two numeric observations. In contrast, AVERAGEA uses all four observations. Do not simply replace one function with the other during spreadsheet migration. [A1]

Imagine four tasks represented as Boolean values in B6:E6: TRUE, TRUE, FALSE, TRUE. These are logical values, not strings containing the words. Enter:

=AVERAGEA(B6:E6)

Expected result: 0.75. Three TRUE values contribute three, while the FALSE contributes zero; 3/4 = 0.75. Format the output cell as a percentage if you want it displayed as 75%. The underlying numeric fraction remains 0.75. This is an independently calculated application of Apple’s documented Boolean conversion rule, not a native Numbers test. [A1]

For a second independently calculated check, a numeric row of 10, 20, 30, 40 in B7:E7 yields =AVERAGEA(B7:E7) → 25, because all four inputs are numbers and (10+20+30+40)/4=25. The example is consistent with the same arithmetic mean definition.

1. Average is unexpectedly low. Look for note strings such as N/A, a, or b in referenced cells. Unlike AVERAGE, AVERAGEA counts that text as zero, which lowers the mean. Verify whether this is intentional. [A1]
2. TRUE/FALSE displayed as words. A cell containing the literal text "TRUE" may not have Boolean semantics. Enter actual Boolean values using the cell’s supported input controls, then inspect the data type before interpreting the result.
3. Dates mixed with durations. Apple’s help explicitly disallows mixing date/time or duration values with other types. Separate those datasets or convert them appropriately before averaging; the precise error label may depend on the application/version and has not been natively tested. [A1]
4. Blank, error, and numeric-text edge cases. Apple’s AVERAGEA page does not exhaustively settle all blank-cell or string-coercion cases. Do not assume Excel’s defaults automatically apply to Numbers; check your real worksheet and native version before publishing a claim about these edge cases.
5. Formula shows an error after pasting. Make sure comma versus semicolon argument separators match your decimal-separator locale, the range is within your table, and you used regular straight quotation marks where text is entered. [L1]
6. Want to ignore text? Use AVERAGE instead and confirm the resulting denominator. AVERAGEA is a different statistical choice, not a more forgiving spelling of AVERAGE. [A1]

Apple Numbers: The string/Boolean conversion used here is established by Apple’s official page. Microsoft Excel: Excel also provides an AVERAGEA function with a similar role, but do not transfer Excel-specific coercion rules, argument counts, or empty-cell handling without separately checking the destination software’s reference. Google Sheets and other spreadsheets: verify the exact function and rules for the specific version being used; formula-name similarity alone is not compatibility evidence. [A1]

For reference, Apple’s documented Boolean example provides the authoritative Numbers behaviour. Export or import should be tested with text-and-Boolean rows, not just a row of numbers.

• AVERAGE in Apple Numbers — skip referenced text rather than count it as zero.
• COUNT in Apple Numbers — count numeric observations for denominator checks.
• IF in Apple Numbers — build a Boolean or conditional classification before aggregating.

• [A1] Apple, “AVERAGEA,” Functions Help 15.4: https://support.apple.com/guide/functions/averagea-ffa5b2784b/15.4/web/1.0 — purpose, exact syntax, supported values, date/duration restriction, zero/Boolean conversions, documented examples and AVERAGE comparison. Documentation checked, accessed 2026-10-12.
• [L1] Apple, “Functions overview,” Functions Help 15.4: https://support.apple.com/guide/functions/functions-overview-ffa083bef0c/15.4/web/1.0 — comma/semicolon localization rule and argument syntax. Documentation checked, accessed 2026-10-12.
• Validation: Three example rows, one AVERAGE comparison and numeric-only/Boolean scenarios were independently calculated; Apple’s corresponding original rows were documentation checked. Native Apple Numbers execution: unavailable, 0 tests.