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.
Returns a number. Ranges ignore text, blanks and logical values; literal arguments are coerced.
The same value behaves differently depending on where it sits. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =SUM(A2:A8) | 360 | Range skips text and the blank |
| =SUM(B2:B8) | 6850 | Whole numeric column |
| =SUM(A2:A8,100) | 460 | Range plus a literal |
| =SUM("5",6) | 11 | Literal text is coerced to 5 |
| =SUM(A2:A8)/COUNT(A2:A8) | 72 | SUM/COUNT equals the mean |
| =SUM(A2:A8,B2:B8) | 7210 | Two ranges added together |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see the range-vs-literal ignore rule.
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.
SUM is a core math function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
SUM is one piece. The full course walks the toolkit end to end with live, measured examples.