
Why your SUM is off by one
The three most common range mistakes and how to spot them.

November 3, 2026
Build a decision in a cell, one condition at a time.

Free, for your email
My free one-page sheet of the twelve formulas I use every week, sent when you sign up. Print it and keep it beside the keyboard.
Sums and counts
Lookups
If and logic
Dates and text

The three most common range mistakes and how to spot them.

Turn text into real dates and count the days between them.