Stat · Nov 16, 2026

The SUM function,
measured & explained.

SUM is the most-used spreadsheet function: it adds every number in its arguments. The subtlety is the ignore rule — inside a range, text, blanks and logical values are skipped, while a literal like "5" or TRUE typed straight into the formula is coerced to a number. Knowing which side of that line you are on explains almost every surprising SUM result.

D1
fx
=SUM(…)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How SUM works

Returns a number. Ranges ignore text, blanks and logical values; literal arguments are coerced.

=SUM(number1, number2, ...)
number1The first number, reference or range to add.
number2, ...Optional additional numbers or ranges (up to 255).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — The ignore rule

Range vs literal arguments

The same value behaves differently depending on where it sits. Click any row to load it.

What SUM counts, and what it skips

ExpressionResultWhy
=SUM(A2:A8)360Range skips text and the blank
=SUM(B2:B8)6850Whole numeric column
=SUM(A2:A8,100)460Range plus a literal
=SUM("5",6)11Literal text is coerced to 5
=SUM(A2:A8)/COUNT(A2:A8)72SUM/COUNT equals the mean
=SUM(A2:A8,B2:B8)7210Two ranges added together
⚠ SUM(A2:A8)/COUNTA(A2:A8) returns 60, not the mean: COUNTA counts the text cell too. Use AVERAGE(A2:A8) or SUM/COUNT, which both give 72.
In a range, SUM ignores text, blanks and logical values. As a literal argument, "5" becomes 5 (Excel also coerces TRUE to 1). Errors in a range propagate.
// 03 — Try it live

Interactive SUM playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see the range-vs-literal ignore rule.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where SUM works

SUM is a core math function present in every Excel version and platform.

PlatformSupportNotesGotcha
✓ Supported full SUM◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master stat

SUM is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Ranges skip text/blanks/logical
  • Literals coerce: "5"→5, TRUE→1
  • SUM/COUNT = AVERAGE, SUM/COUNTA does not
  • Errors propagate; guard with IFERROR
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked