Reproduce the result without a formula
The common five-row CSV contains three North records, but only two are Open. Their amounts are 125 and 75. Their mean is (125 + 75) / 2 = 100. This independent arithmetic is the check value for all candidates above.
The AVERAGEIFS parameter order is average range, then pairs of condition range and condition. It resembles SUMIFS more than AVERAGEIF. In one-condition variants, the average range may appear last, so don’t migrate solely by memorizing the function’s name.
Avoid averaging all North rows
A tempting mistake is AVERAGEIF(A2:A6;"North";C2:C6) or its comma-separated counterpart. That includes North/Closed (50), so it answers a different question. The mean of all North amounts would be 250 / 3 ≈ 83.33 rather than 100.
An older-engine workaround can divide the SUMPRODUCT of matching amounts by the count of matching rows. However, zero matching rows makes that denominator zero. A real statistical report should distinguish “no matching observations” from a valid observed zero.
What to verify in the destination application
- All three ranges must cover the same five data rows, not the headers.
- Ensure the Region and Status values are text, not inadvertently converted to labels with trailing spaces.
- Check the zero-match case (
WestandClosed) and document whether a blank, error or explicit “No records” is appropriate to your report. - Confirm range syntax after importing CSV into a named table in Apple Numbers; references may be qualified by table name.
- If using the SUMIFS/COUNTIFS fallback, verify that both functions interpret criteria identically and that the denominator is not zero.
For totals rather than averages, see SUMIFS with two conditions.
Documentation and testing disclosure
Official vendor sources and version scopes appear beside each software candidate above. Expected outputs are independently reasoned from the shared sample; the five new comparisons do not claim native execution in any of the eight applications. Read more about how we distinguish documentation from execution in our editorial standards.