Criteria · eight-software comparison

COUNTIFS across spreadsheet programs

Count rows satisfying two conditions, compare COUNTIFS argument patterns, and identify a documented fallback for Calligra Sheets.

Task

Count rows where Region is North (A2:A6) and Status is Open (B2:B6).

Expected output

Compatibility trap: All criterion ranges must align in shape; counting blanks, text comparison rules and regional separators may differ.

One shared five-row test dataset

The same source rows make results easier to compare. Use the CSV in any supported spreadsheet application; the ODS workbook also includes LibreOffice formula tests.

Sample data (.csv) ↓Calc test workbook (.ods) ↓

Shared formula comparison fixture (columns A through F)
Region (A)	Status (B)	Amount (C)	SKU (D)	Label (E)	Units (F)
North	Open	125	SKU-101	Alpha	2
South	Closed	80	SKU-102	Beta	1
North	Open	75	SKU-103	Gamma	3
North	Closed	50	SKU-104	Delta	4
South	Open	200	SKU-105	Epsilon	1

Formula syntax and feature differences

“Documented” rows cite official product help, but were not run in the destination software. A formula shown here is a migration candidate, not a guarantee of identical behaviour or file interoperability.

LibreOffice Calc

Native tested

Version: Calc 25.2.3.2 verified.

Arguments: COUNTIFS(range1;criterion1;range2;criterion2;…)

=COUNTIFS(A2:A6;"North";B2:B6;"Open")

Counts two North/Open rows in the supplied five-row fixture.

Official documentation ↗

Apache OpenOffice Calc

Documented

Arguments: COUNTIFS(criteria_range1;criterion1;…)

=COUNTIFS(A2:A6;"North";B2:B6;"Open")

COUNTIFS is present in the official Apache OpenOffice function list; do not confuse guide coverage gaps with missing software functionality.

Official documentation ↗

Gnumeric

Documented

Arguments: COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,…)

=COUNTIFS(A2:A6,"North",B2:B6,"Open")

Gnumeric’s published function index records COUNTIFS as complete with basic testing.

Official documentation ↗

Calligra Sheets

Alternative

Arguments: Row helper formula, then SUM(helper column)

=IF(AND(A2="North";B2="Open");1;0)

Official KDE function handbook documents COUNTIF but does not list COUNTIFS. For a transparent alternative, fill this helper down C2:C6 and SUM(C2:C6); keep source Amount out of helper column.

Alternative: Use a new blank column G to avoid overwriting Amount; change example helper cell to G2.

Official documentation ↗

PlanMaker

Documented

Version: PlanMaker 2026.

Arguments: COUNTIFS(range1;criterion1;range2;criterion2;…)

=COUNTIFS(A2:A6;"North";B2:B6;"Open")

The 2026 manual documents COUNTIFS and warns that older file formats can lose native formula compatibility.

Official documentation ↗

ONLYOFFICE Spreadsheet Editor

Documented

Arguments: COUNTIFS(criteria_range1,criteria1,…)

=COUNTIFS(A2:A6,"North",B2:B6,"Open")

Published function help documents multi-range criteria and common wildcard handling.

Official documentation ↗

Apple Numbers

Documented

Arguments: COUNTIFS(test-values,condition,…)

=COUNTIFS(A2:A6,"North",B2:B6,"Open")

Numbers has a COUNTIFS function. References assume source columns belong to a Numbers table.

Official documentation ↗

Zoho Sheet

Documented

Arguments: COUNTIFS(criteria_range1;criterion1;…)

=COUNTIFS(A2:A6;"North";B2:B6;"Open")

Zoho Sheet documentation uses semicolon-separated criteria pairs.

Official documentation ↗

What changes when you migrate?

A safe test needs both a row that meets only the first condition and a row that meets only the second, so accidental OR logic is exposed.

Calligra fallback: in G2 enter =IF(AND(A2=“North”;B2=“Open”);1;0), fill through G6, then =SUM(G2:G6). This is an editorial workaround, not a claimed Calligra COUNTIFS implementation.

Region-aware separators are not a property of the named function itself: some installations use commas and others semicolons.

Actual LibreOffice calculation evidence

Formula tested in LibreOffice Calc 25.2.3.2. The published manifest provides the exact input formula, checked result, and whether the test validates a scalar result rather than array spill layout.

Test ID: countifs. See calculation results (JSON).

Two criteria means intersection, not union

Only rows that meet both conditions qualify. The first North/Open row has amount 125, and the second has amount 75, but COUNTIFS is counting rows—not summing those amounts—so the answer is 2. North/Closed must not count; neither should South/Open.

Practical fallback in a helper column

Calligra’s public function handbook documents single-criterion counting but does not supply a COUNTIFS entry in the material reviewed for this release. To keep the method transparent, enter this into blank cell G2, then fill down through G6:

=IF(AND(A2="North";B2="Open");1;0)

Then evaluate =SUM(G2:G6) to obtain 2. This helper formula is a proposed workaround based on documented IF, AND and SUM primitives; it was not runtime-tested in Calligra. Never place it in column C, which contains the Amount data in this fixture.

Avoid three silent mistakes

A COUNTIF of North plus a COUNTIF of Open would double-count rows and is not the same as logical AND.
Each criteria range must cover the same five rows, without an off-by-one error.
Depending on locale, arguments may be separated by a comma instead of a semicolon. Prefer the destination editor’s formula insertion tools when transferring examples.