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

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.

gif.gif

 

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

gif_1.gif

 

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.

gif_2.gif

 

· 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!.

gif_3.gif

 

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. 

gif_4.gif