# Why error message #NULL! occurs and how to solve it

Uploaded time: February 28, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

Why error message #NULL! occurs and how to solve it

# 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.

· **T****he 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.

· **T****he 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.

Trending Tutorials

Does this video help you?