SUM function

Syntax

Square brackets indicate optional arguments.

Arguments

Practice a complete task

• Weight a workload by its case counts →

  Combine per-case estimates using the number of cases instead of giving every service the same influence.

• Build a filtered priority queue with a stable tie rule →

  Select one team at or above a points threshold, then sort the complete records by points descending and numeric ticket ascending.

• Group posted net units by region →

  Filter order status before summing repeated regions, including returns and numeric zeroes.

• Compare annual charges and the remaining carrying value →

  Use SLN and SYD on the same cost, salvage and useful life, then reconcile cumulative SYD allocation.

• Compare fixed and accelerated declining balances →

  Keep DB rate rounding, first-year months, DDB factors and the final fiscal stub explicit.

• Compare exact, cumulative and interval event counts →

  Build a complete binomial report for a fixed number of independent trials with one constant event probability.

• Compare finite sampling with a replacement model →

  Calculate a sample-count report without replacement, then compare it with independent draws at the same starting proportion.

• Scale an event-count model to its observation window →

  Convert a rate per base interval to a window mean, then report exact, cumulative, interval and upper-tail event probabilities.

• Audit row-wise Boolean masks and counts →

  Convert real Booleans to 0/1, combine row conditions with AND and OR, and reconcile counts without double-counting overlaps.

• Copy expanding ranges into complete running totals →

  Keep the first source row fixed, move the endpoint with each entry and copy the same seed across two signed measures.

• Compare OFFSET and INDEX dynamic ranges →

  Use one row-count input to resize two real reference methods, then compare their totals, means and selected populations.

• Count numbers, text, logical values and blank-like cells →

  Reconcile four disjoint stored types and explain why COUNTA plus COUNTBLANK can exceed the number of cells.

• Compare mean populations without changing stored types →

  Keep numeric zeroes, excluded text and explicit mean denominators visible before choosing an averaging rule.

• Compare formula operators and their evaluation order →

  Compare all four operator classes on real inputs: numeric order, Boolean comparisons, text joining and range/union/intersection references, plus an actual spill helper and row-dependent implicit intersection.

Reference and compatibility

• Microsoft function documentation ↗

Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.