SUMIF Function in ONLYOFFICE Spreadsheet Editor: Examples and Syntax
SUMIF in ONLYOFFICE Spreadsheet Editor: sum sales for one product category using practical sample data, clear expected results, pitfalls and the official function documentation.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked
Quick answer: Sum sales for one product category. A small shop wants the total revenue from books while other product categories remain in the same sales table.
This page covers the ONLYOFFICE Spreadsheet Editor implementation specifically. Its example values and expected results are original educational data, not screenshots or claims of a live application test.
Syntax and argument order
=SUMIF(range, criteria, [sum_range])
The argument order above follows the official ONLYOFFICE Spreadsheet Editor documentation. Use the function name shown here, and replace placeholder arguments with ranges, cell references or criteria from your workbook.
Worked example with sample data
| Row | A: Category | B: Revenue |
|---|---|---|
| 2 | Books | 12 |
| 3 | Games | 20 |
| 4 | Books | 15 |
| 5 | Office | 18 |
| 6 | Books | 30 |
Enter this formula in a free result cell (outside the input range):
=SUMIF(A2:A6,"Books",B2:B6)
Expected result: 57.
Why this result is correct: The matching amounts are 12, 15 and 30. SUMIF adds the revenue values in column B only when the same row in column A says Books.
A second example or variation
=SUMIF(A2:A6,"Games",B2:B6)
Expected result: 20.
Changing only the category yields the Games total. This is convenient for a dashboard where the requested category comes from an input cell.
Common mistakes and troubleshooting
Check that the test range and sum range cover the same rows. If amounts were imported as text, first convert them to numeric values.
Also check that the version of ONLYOFFICE Spreadsheet Editor you use supports this function. A formula pasted from another application can fail because of different syntax, date interpretation, array behavior or regional separators. If the result differs, first compare the small dataset above with the expected answer before substituting your real data.
Where this function helps
A small shop wants the total revenue from books while other product categories remain in the same sales table. Replacing the sample cells with your own ranges lets you reuse the same reasoning. On important spreadsheets, test with a few known rows, verify the final cell formatting and keep a separate copy of the source data.
Practical checks before reusing this formula
Check argument order carefully: the optional sum range belongs after the criterion. Omitting it sums values in the criteria range rather than in a separate totals column.
When a CSV import has left monetary values as text, correct the data type before trusting a SUMIF result.
To compare this function with other spreadsheet programs, use our eight-software function comparison. A missing guide does not mean a function is unsupported in another product; check its official documentation.
Official reference and verification
- Official ONLYOFFICE Spreadsheet Editor — SUMIF reference
- Verification status: Official documentation checked; example outcome 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.