Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Why error message #NULL! occurs and how to solve it
Uploaded time: February 28, 2022 Difficulty Beginner
Why error message #NULL! occurs and how to solve it
![](http://res-academy.cache.wpscdn.com/static/cover/big_xls.png)
Why error message #NULL! occurs and how to solve it
You may not know what to do if the error message #NULL! occurs when carrying out calculations in a table. Today, I'll talk about why the error message #NULL! occurs and how to solve it.
In general, the error message #NULL! is caused by the lack of the reference operator in references, resulting in an empty range of references.
· The formula references continuous cell range without the correct reference operator.
Take this table as an example. If we want to sum up the company's sales of all machines in the first quarter, input =SUM(C3 C8)in C10, and it returns #NULL!.
That is because we didn't use the correct reference operator when referencing the continuous cell range of C3:C8.
The solution is to add a : to split the first and last cells, so we input =SUM(C3:C8) to get the result.
· The formula references discontinuous cell ranges without the correct reference operator.
If we want to sum up the sales of all machines in the first and third quarter, input =SUM(C3:C8 E3:E8)in D11, and then it returns #NULL!.
That is because we didn't use the correct reference operator between the two discontinuous cell ranges C3:C8 and E3:E8.
The solution is to add a , to split these two cell ranges, so we input: =SUM(C3:C8,E3:E8) to work out the sum.
Also Read:
- 1. Why error message #DIV0! occurs and how to solve it
- 2. Why error message #VALUE! occurs and how to solve it
- 3. Why error message #REF! occurs and how to solve it
- 4. Why error message #NAME? occurs and how to solve it
- 5. Why error message #NUM! occurs and how to solve it
- 6. Why error message NA occurs and how to solve it
Does this video help you?