DSUM Function in ONLYOFFICE Spreadsheet Editor: Examples and Syntax
DSUM in ONLYOFFICE Spreadsheet Editor: sum a data table using a separate criteria area using practical sample data, clear expected results, pitfalls and the official function documentation.
Reference checked: Examples have not been run in this spreadsheet application. How we verify guides
Quick answer: Sum a data table using a separate criteria area. Database functions treat a first row as column headers and use a separate criteria range. This is useful when several dashboard criteria can change independently of the underlying 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
=DSUM(database, field, criteria)
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: Region | B: Product | C: Revenue |
|---|---|---|---|
| 1 | Region | Product | Revenue |
| 2 | North | Pens | 100 |
| 3 | South | Pens | 75 |
| 4 | North | Paper | 180 |
| 5 | North | Pens | 140 |
Set E1 to Region and E2 to North.
Enter this formula in a free result cell (outside the input range):
=DSUM(A1:C5,"Revenue",E1:E2)
Expected result: 420.
Why this result is correct: The criterion keeps all three North records, so 100 + 180 + 140 = 420. DSUM finds the field by its exact header text, Revenue.
A second example or variation
=DSUM(A1:C5,3,E1:E2)
Expected result: 420.
The field number 3 points to the third column of the database and gives the same result.
Common mistakes and troubleshooting
The criteria header must match the database header. Keep the criteria range separate from the data range, and include both the header and at least one criteria row.
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
Database functions treat a first row as column headers and use a separate criteria range. This is useful when several dashboard criteria can change independently of the underlying 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
Database functions depend on a well-formed header row and a separate criteria range whose field headings correspond to those in the source table. A tiny header mismatch can invalidate the match.
For simple flat lists, SUMIFS may be easier to audit. DSUM is more useful when you maintain a reusable criteria table.
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 — DSUM 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.