AVERAGE Function in ONLYOFFICE Spreadsheet Editor: Examples and Syntax

=AVERAGE(number1, [number2], ...)

Square brackets are documentation markers for optional parameters, not characters to type in a formula. Formula names and comma-separated arguments here follow ONLYOFFICE’s official function-entry guide. Locale settings can affect punctuation and displayed formats.

Create a new sheet with these small source records:

If a cell is marked leave empty, leave it truly empty rather than entering the words in the table. Put the formula in a free cell away from the source data.

=AVERAGE(B2:B6)

Expected result: 25. Four numeric cells total 100; the empty B5 is not an observation, so 100 / 4 = 25. Do not literally enter the instructional text in B5. This is an arithmetic/logical prediction on the supplied sample, not a claim of native ONLYOFFICE testing.

=AVERAGE(B2:B4)

Expected result: 20. (10 + 20 + 30) / 3 = 20. Comparing these two results helps identify incorrect ranges and mismatched conditions.

Enter the number zero into the previously empty B5.

=AVERAGE(B2:B6)

Expected result: 20. Now five numeric observations total 100; 100 / 5 = 20. Change just the source value described above to reproduce the variation.

A truly empty cell differs from the number zero. AVERAGEA handles text/logical values differently. No meaningful average exists if the range contains no numeric observations.

Unrecognized formula names, missing arguments, incorrect parentheses and incompatible separators may cause an error. When an output is surprising, test the small example first, check whether input values are genuine numbers, then inspect the formula’s range endpoints. Do not guess a specific error label when it has not been produced by a native test.

Use COUNT(B2:B6) to verify the number of numeric observations: four before adding zero, five afterward. Check whether imported numbers were stored as text. If formulas are displayed as text, ensure the destination cell is treated as a formula and starts with an equals sign. If copying a formula, decide which references should remain fixed and apply $ anchors as needed.

The current official function inventory lists this function. The checked changelog does not give its first supported build. Verify the installed edition rather than implying unsupported old builds work.

The official changelog was reviewed on 2026-10-11 UTC. No unsupported introduction date or minimum edition is invented.

Excel and Google Sheets use AVERAGE; recheck blank-versus-zero and data import behaviour. Microsoft also provides a version-aware function catalogue. Consult the eight-software comparison for navigation, but verify formula semantics in each destination app before copying a workbook.

• COUNT guide
• AVERAGEIF guide

• ONLYOFFICE Spreadsheet Editor — function documentation
• ONLYOFFICE’s official function-entry guide
• official changelog

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.