sum function in cell formula


Version: 2025b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-20245


Total( ) function is used to get sum of region, while Sum( ) is used to get cumulative sum for a column.

In Origin 2025b, when sum() function is used in cell formula, it will get the total of the region. E.g. sum(A1:A10), sum(A1:D1), sum(A1:D10), sum(A1:B1, E1:F1).

Note: sum(A1:B1, E1) not supported still.