SUMA Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Math module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

SUMA adds all nonempty collected values using the full-value addition path. Numeric strings are parsed, TRUE/FALSE become 1/0, and nonnumeric strings contribute zero in the tested calls. It is not string concatenation and does not count how many inputs were supplied. Function-specific official reference.

=SUMA(value1[;value2;...])

Supply one or more values or arrays. Separate arguments with semicolons. Inline-array elements are walked before addition. Brackets indicate optional arguments and are not entered in the formula. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

SUMA(1;2;“9”) gives 12, while replacing “9” with “abc” gives 3. The difference comes from conversion, not from an arithmetic rounding rule. SUMA({TRUE();FALSE();“9”}) gives 10 because its contributions are 1,0 and 9.

For quantities 2,4,8 the sum is 14. Keep a status column separate from an amount column unless counting a TRUE as one unit is intentional. SUMA can produce a reasonable total while silently treating an invalid text amount as zero.

For clean numeric inputs, summation is additive across disjoint groups. For example, (1+2)+(3+4)=10, matching one sum over 1,2,3,4. The choice of which elements enter the sum is as important as this arithmetic.

The executed comparison subtracts SUM(1;2;“9”) from SUMA(1;2;“9”). SUM uses its numeric-only collection for this direct argument list and gives 3; SUMA includes the parsed text and gives 12. The difference is 9. Explicitly normalize imported data if all downstream calculations should use the same convention.

The executed advanced check was:

=SUMA(1;2;"9")-SUM(1;2;"9")

Its engine result was 9.

An actual error remains an error: the tested 1/0 arguments propagate #DIV/0!, including errors inside inline arrays. This differs from a nonnumeric string, which converts to zero. An empty string is also converted to zero in the listed tests.

No arguments gives #VALUE!. The guide does not claim native tests of blank worksheet cells, range imports or localized numeric strings. Aggregation may conceal invalid textual amounts even when it correctly propagates formula errors.

• Function-specific implementation
• Versioned function help
• Aggregation helper
• Addition helper
• Conversion helper
• Sum helper
• Defaults helper
• Array Parser helper

The math module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

SUM, COUNTA, AVERAGEA.