The #NULL! error is one of the rarest Excel errors, which is exactly why it's confusing when it appears. It means you used the intersection operator — a space — between two ranges that don't actually intersect. Here's what that means and how to fix it.

What #NULL! means

Excel has a little-known operator: a space between two ranges means "the intersection of these ranges" — the cells they share in common. #NULL! appears when you ask for the intersection of two ranges that have no cells in common. There's no overlap, so the result is null.

Most people who hit this error didn't intend to use the intersection operator at all — they typed a space by accident where they meant a comma or colon.

The most common cause: a typo

A space instead of a comma. If you meant to sum two separate ranges:

=SUM(A1:A5 C1:C5)     ← wrong: space between ranges

That space tells Excel to find the intersection of A1:A5 and C1:C5, which don't overlap — so #NULL!. The fix is a comma:

=SUM(A1:A5, C1:C5)    ← correct: comma sums both ranges

A space instead of a colon. If you meant a single continuous range:

=SUM(A1 A5)           ← wrong
=SUM(A1:A5)           ← correct: colon makes it a range

These accidental spaces are the overwhelming cause of #NULL!.

The rare intentional use

The intersection operator does have legitimate uses. If two ranges do overlap, the space returns their shared cells:

=SUM(A1:C3 B1:B10)

Here A1:C3 and B1:B10 both include B1, B2, B3, so this sums that overlap. This is occasionally handy with named ranges — =Sales Q1 could return the intersection of a "Sales" row-range and a "Q1" column-range. But if the ranges don't overlap, you get #NULL!.

How to fix it

1. Look at the formula for spaces between ranges or references. That's almost always the culprit.
2. Decide what you meant:
   • Separate ranges to combine? Use a comma: SUM(A1:A5, C1:C5).
   • One continuous range? Use a colon: SUM(A1:A5).
   • An actual intersection? Make sure the ranges genuinely overlap.
3. Replace the errant space with the correct operator.

How to avoid it

• Be deliberate about commas and colons when writing multi-range formulas.
• When selecting ranges by clicking, use Ctrl to add separate ranges (Excel inserts commas automatically) rather than typing spaces.
• If you see #NULL!, your first instinct should be "where's the stray space?"

The takeaway

#NULL! is niche: it means you asked for the intersection of two ranges (via a space) that don't overlap. In practice it's almost always an accidental space that should have been a comma or colon. Find the space, replace it with the right operator, and the error clears. Once you know the space-means-intersection rule, this error stops being mysterious.