Fix an error
Fix the #NULL! error
What to do
- #NULL! usually means a comma or colon is missing between two references.
- Use a colon for a range, such as A2:A5.
- Use a comma to separate items, such as A2,B2.
Good to know
- In a formula, a space means "where these ranges overlap".
The idea in general
Excel was told to look where two ranges meet, and they do not meet.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.