#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!.
a formula that produces it
=SUM(A1:A2 B1:B2)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