Goal: Define which cells to include.
Excel has three operators: Range (:), Union (,), and Intersection (Space).
A
B
C
D
E
Range 1 (B2:D4)
Range 2 (C3:E5)
Ready...
💻 Formula Structure
=SUM(Start:End)
Symbol: Colon (:).
Meaning: All cells between the start and end points, inclusive.
=SUM(Range1, Range2)
Symbol: Comma (,).
Meaning: Combines multiple ranges. Includes BOTH areas.
=SUM(Range1 Range2)
Symbol: Space character ().
Meaning: Only cells shared by BOTH ranges (The Overlap).
-- Select an operator...
...
Count:
-
⚠️ The Null Error
🚫 #NULL!
This error appears if you use the Intersection Operator (Space) on two ranges that do NOT overlap at all (e.g., A1 A5). Excel finds 0 overlapping cells.