# #NULL!

two ranges were intersected but do not overlap.

## what it means

A space between two references is the intersection operator. When the two ranges share no cells, the intersection is empty and the formula returns #NULL!.

## common causes

- a missing comma between arguments, e.g. =SUM(A1:A2 B1:B2) instead of =SUM(A1:A2, B1:B2)
- a deliberate intersection of ranges that do not overlap

## how to fix it

- add the missing comma or colon between the references
- if you meant an intersection, use ranges that actually share cells

## related

#VALUE! · #REF!

## navigate

- [all error values](https://deepcalc.com/errors.md)
- [function index](https://deepcalc.com/functions.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/errors/null