- New
- Spreadsheet
Average numeric cells with AVERAGEIF
AVERAGEIF averages the criteria range, or the same-shaped block anchored at the average range top-left. No numeric match is #DIV/0!. Wildcards fail closed.
- Top-left alignmentAVERAGEIF(A1:A3,"apple",C1) reads C1:C3 and is 10, not only C1.
- Empty average is #DIV/0!Text and blanks are ignored. Zero numeric matches is division by zero, not a partial average.
- Wildcards fail closedUnescaped * and ? are rejected in both the native engine and the browser kernel.
