Why the argument order matters
The shared CSV places Region in column A, Status in B and Amount in C. The desired rows are:
| Region | Status | Amount |
|---|---|---|
| North | Open | 125 |
| North | Open | 75 |
| Total | 200 |
The other North row is Closed and therefore excluded. This is a two-condition logical AND, not an OR across the two columns. The total, 200, is independently calculated from the fixture, not the result of executing each formula in all eight applications.
SUMIF is not just a shorter SUMIFS
For SUMIFS, the first argument is the values to sum; criteria ranges and criteria follow. In a single-criterion SUMIF, many spreadsheet applications instead place the criterion before the optional sum range. Mixing the two orders can return the wrong total or a parameter error. LibreOffice, PlanMaker, ONLYOFFICE, Apple Numbers and Zoho publish SUMIFS references, while Gnumeric also documents SUMIFS. The versions and argument separators are recorded in the comparison above.
Why a SUMPRODUCT workaround needs testing
The boolean-expression alternative multiplies each row’s value by 1 only if both comparisons match. In some engines, array evaluation and how text values are coerced affect the outcome. The suggested alternative is not an assertion that SUMIFS is missing from that program, and it has not been run in each destination engine.
Common mistakes: using an amount range one row shorter than its criteria ranges, mistyping a label, accidentally matching a regex pattern rather than literal text, and treating blank and zero as interchangeable.
Verification checklist
- Confirm the header layout in the actual import and use the same row limits for all three ranges.
- Check the North/Open rows individually; the expected 125 + 75 is 200.
- Change one Open row to Closed to ensure the total responds correctly.
- Test a zero-match pair. A sum of zero might be valid even when no records were selected; report the count separately if that matters.
- When exporting between ODS and XLSX, reopen the workbook and recalculate before trusting displayed cached totals.
Continue with the COUNTIFS comparison if you need the number of matching records rather than their total.
Documentation and testing disclosure
Official vendor sources and version scopes appear beside each software candidate above. Expected outputs are independently reasoned from the shared sample; the five new comparisons do not claim native execution in any of the eight applications. Read more about how we distinguish documentation from execution in our editorial standards.