AVERAGE
Supported, behaves as documentedCategory: Statistical · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =AVERAGE(A1:A4) | Basic average of 4 numbers | 5 | 5 | Matched |
| =AVERAGE(A1:A5) | Text values and blank cells in the range are excluded from both the sum and the count, rather than being treated as 0 | 20 | 20 Only A1, A3, A5 (10, 20, 30) are numeric; average = 60/3 = 20. If blanks/text counted as 0 the result would be 12 |
Matched |
| =AVERAGE(A1:A3) | A range containing only text has zero numeric values to average -> #DIV/0! | #DIV/0! | #DIV/0! | Matched |
| =AVERAGE(A1:A3) | A fully empty range also has zero numeric values -> #DIV/0! | #DIV/0! | #DIV/0! | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation