Math · eight-software comparison

SUMPRODUCT weighted totals

Multiply price by units for each row then sum the products; document array shape and syntax compatibility.

Task

Sum Amount × Units for each of five rows, using C2:C6 and F2:F6.

Expected output

955

Compatibility trap: SUMPRODUCT needs compatible vector dimensions and numeric values; text coerces differently across products.

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: Tested 25.2.3.2.

Arguments: SUMPRODUCT(array1;array2;…)

=SUMPRODUCT(C2:C6;F2:F6)

2×125 + 1×80 + 3×75 + 4×50 + 1×200 = 955.

Official documentation ↗

Apache OpenOffice Calc

Documented

Arguments: SUMPRODUCT(array1;array2;…)

=SUMPRODUCT(C2:C6;F2:F6)

A long-established array aggregation documented in the Calc functions index.

Official documentation ↗

Gnumeric

Documented

Arguments: SUMPRODUCT(array1,array2,…)

=SUMPRODUCT(C2:C6,F2:F6)

Gnumeric published index marks SUMPRODUCT complete with basic testing.

Official documentation ↗

Calligra Sheets

Documented

Arguments: SUMPRODUCT(array1;array2)

=SUMPRODUCT(C2:C6;F2:F6)

KDE handbook explicitly gives a two-array product summation example and equal-length requirement.

Official documentation ↗

PlanMaker

Not researched

The PlanMaker pages reviewed for this release do not establish exact SUMPRODUCT syntax; no compatibility conclusion.

Official documentation ↗

ONLYOFFICE Spreadsheet Editor

Not researched

No first-party SUMPRODUCT page was reviewed in this research pass.

Official documentation ↗

Apple Numbers

Documented

Arguments: SUMPRODUCT(array1,array2,…)

=SUMPRODUCT(C2:C6,F2:F6)

Apple includes SUMPRODUCT among its numeric functions; this copied formula was not independently executed in Numbers.

Official documentation ↗

Zoho Sheet

Not researched

No Zoho SUMPRODUCT function-specific entry was inspected in this patch.

Official documentation ↗

What changes when you migrate?

Keep the two dimensions identical: C2:C6 and F2:F6 both contain five entries.

A basic SUMPRODUCT gives weighted totals without a helper column; it is not a replacement for every multi-condition array query.

A platform’s function index may establish implementation, but this fixture was only executed in LibreOffice.

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: sumproduct. See calculation results (JSON).

A clear weighted-total sanity check

For each row, multiply Amount by Units and sum the results:

SKU	Amount	Units	Extended
SKU-101	125	2	250
SKU-102	80	1	80
SKU-103	75	3	225
SKU-104	50	4	200
SKU-105	200	1	200
Total			955

The native LibreOffice test returns 955. The Gnumeric function index also lists SUMPRODUCT as implemented, and the Calligra handbook explicitly documents a two-array form. Those are documentation checks, not executions in those applications.

Hidden edge cases

Array length mismatches, text in numeric columns, empty cells and error values require separate test rows. For financial or inventory spreadsheets, store numeric amounts as numbers rather than formatted strings. Always validate a sample output against hand multiplication before trusting large data migrations.