Excel #NULL! Error — What It Means & How to Fix It

What Does This Error Mean?

The #NULL! error in Excel means your formula is trying to find where two cell ranges overlap — but they don't actually overlap. This usually happens when you accidentally use a space between two ranges instead of a comma or a colon. It is easy to fix once you spot the mistake.

Affected Models

Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel for Microsoft 365

Common Causes

A space was accidentally typed between two cell ranges instead of a comma or colon
The formula uses the space (intersection) operator on purpose, but the ranges named do not actually intersect
Two named ranges were referenced with a space between them instead of a comma
A copy-paste action introduced an invisible character or space into the formula
The formula was built for a different spreadsheet layout where the ranges did overlap, but the layout has since changed

How to Fix It

Click the cell showing #NULL! and look at the formula in the formula bar. Look for any spaces between cell references or range names.

A space between ranges (like A1:A5 B1:B5) is the intersection operator — it is only valid when the ranges actually overlap.
If you meant to add two separate ranges together, replace the space with a comma. For example: =SUM(A1:A5,B1:B5) not =SUM(A1:A5 B1:B5).

The comma tells Excel to include both ranges in the calculation.
If you meant to specify a continuous range, use a colon instead. For example: =SUM(A1:B5) covers all cells from A1 to B5.

The colon means 'from this cell to that cell' — it creates one connected range.
If the formula uses named ranges with a space between them, go to Formulas > Name Manager and verify that those named ranges genuinely share cells in common.

If they do not share any cells, they cannot intersect, and you will always get #NULL!.
After fixing the operator, press Enter to confirm the formula. If the error is gone, check nearby cells to make sure no similar formulas are affected.

If you copy-pasted this formula across multiple cells, the same error may appear in other cells too.

When to Call a Professional

The #NULL! error is entirely a formula issue and does not indicate any software problem. You can fix it yourself by editing the formula. If the spreadsheet was built by someone else and the formulas are very complex, ask them to review the layout changes.

Frequently Asked Questions

What is the intersection operator in Excel?

The intersection operator is a space character between two range references. It tells Excel to return only the cells that both ranges have in common. For example, =SUM(A1:A10 A5:A15) would sum only cells A5:A10 — the overlap. This is a real feature, but it causes #NULL! when the ranges don't overlap at all.

Can #NULL! appear without me typing a space?

Yes. If you copied a formula from another source (like a website or another spreadsheet), an invisible space may have been pasted in. Click inside the formula bar and look carefully — sometimes the space is hard to see between range references.

Is the #NULL! error dangerous — will it corrupt my spreadsheet?

No. #NULL! is a display error only. It means Excel cannot calculate that cell, but it does not damage the rest of your spreadsheet. Fix the formula and everything returns to normal instantly.