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

November 5, 2026
Find a value in a table without scrolling for it.

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.