SUMPRODUCT Function (Gnumeric)
Learn the SUMPRODUCT function in Gnumeric: (Inner products) Returns the sum of the products of array arguments.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked
Quick answer
SUMPRODUCT multiplies corresponding items from equally sized numeric ranges, then adds the products. It is a compact way to calculate line-item totals.
Gnumeric syntax and parameters
=SUMPRODUCT(array1,array2,...)
array1 — First numeric range or array of values.
array2, ... — Corresponding equally dimensioned numeric arrays; values in the same positions are multiplied.
Version and locale scope: The release-scoped function registry confirms SUMPRODUCT within the Gnumeric 1.12.62 standard public function set (September 2026). The Gnumeric manual documents the syntax shown here but is a continuously updated reference, not a frozen 1.12.62 manual. The function’s original introduction version has not been established. The formulas below use comma-separated English-locale syntax; installed regional settings or imported files may display other separators. Availability can depend on installed plugins and builds for Gnumeric functions in general.
Reproduce the example in your own worksheet
Prepare three numeric columns. The payment factor is 1 for no discount, 0.9 for a 10% discount and 0.8 for a 20% discount.
On a narrow screen, scroll this table sideways to see every column.
| Row | D: Quantity | E: Unit price | F: Payment factor |
|---|---|---|---|
| 2 | 2 | 12 | 1 |
| 3 | 3 | 10 | 0.9 |
| 4 | 1 | 25 | 0.8 |
| 5 | 4 | 8 | 1 |
Do not put currency symbols into input strings; format numerical cells as currency after entering numeric prices.
- Enter the values in the indicated cells in Gnumeric.
- Select a separate blank result cell outside the input range.
- Enter this formula exactly as written for the sample input:
=SUMPRODUCT(D2:D5,E2:E5)
Expected result: 111. Each line total is quantity × unit price: 2×12=24, 3×10=30, 1×25=25 and 4×8=32. Summing 24+30+25+32 gives 111.
Input interpretation: The official page shows a synopsis without parameter labels; this explanatory syntax uses array1,array2, … as meaningful placeholders, not a verbatim Gnumeric synopsis. Exact ordering and arity remain subject to a native review.
Advanced application: add a useful check or calculation
After reproducing the basic result, enter:
=SUMPRODUCT(D2:D5,E2:E5,F2:F5)
Expected result: 103. The third range contains per-line payment factors 1, 0.9, 0.8 and 1. The revised contributions are 24+27+20+32 = 103.
This is a teaching example, not an assertion that the formula has been executed in this software version.
Third worked example: calculate a quantity-weighted unit price
=SUMPRODUCT(D2:D5,E2:E5)/SUM(D2:D5)
Independently calculated expected result: 11.1. The total extended price is 111 and total quantity is 10. Dividing produces 11.1 per unit, rather than the unweighted average of the four listed prices. This example assumes a nonzero total quantity and uses the undiscounted price column.
Errors, edge cases and troubleshooting
- Gnumeric explicitly reports #VALUE! for arrays/ranges with different dimensions. Keep all ranges the same length and shape.
- The manual says nonnumeric entries contribute zero, so a blank or text price silently changes the total. Audit each input column.
- Gnumeric documents that ordinary SUMPRODUCT ignores logical values; it suggests coercion such as –(A1:A5>0) for comparison tests. ODF.SUMPRODUCT differs by considering booleans.
If the output differs, first confirm the exact cell contents and range boundaries; use an independent small dataset to isolate a formula issue from imported formats, hidden characters or missing values. Keep result cells outside the input ranges to avoid accidental circular references. Do not hide an error with IFERROR until you know which input is responsible.
Limits and cross-software compatibility
Gnumeric calls SUMPRODUCT Excel compatible but explicitly not OpenFormula compatible; for OpenDocument semantics it directs readers to ODF.SUMPRODUCT. That distinction matters when mixing boolean data.
Gnumeric reference coverage is not a claim that every formula behaves identically in Microsoft Excel, LibreOffice Calc, Apple Numbers or other spreadsheet apps. Review the receiving application’s argument conventions, cell types and version-specific behavior before relying on workbook portability.
More related Gnumeric tutorials
Official sources and verification status
- Official Gnumeric Mathematics function reference — SUMPRODUCT (checked 2026-10-11).
- Gnumeric official function catalog (checked 2026-10-11; its headline/row totals are not treated as the canonical release count).
- Gnumeric 1.12.62 official release notes (release dated September 2026, checked 2026-10-11).
How this guide was checked
The syntax and behaviour are based on the Gnumeric references cited above. The sample calculations were independently checked; they are expected results, not outputs observed in Gnumeric. Test locale-sensitive text conversion and imported files in your own installation. View the example-check record.