How to fix the #NULL! error
The #NULL! error is quite rare in Excel, and is usually the result of a typo where a space character is used instead of a comma (,) or colon (:) between two cell references. Technically, the space character is the "range intersect" operator and the the #NULL! error is reporting that the two ranges do not intersect. This is baffling to the average user but in most cases replacing the space with a comma or colon as needed will fix the problem.
Example 1 - space instead of colon
In the screen below, the formula in C9 returns the #NULL error:
=SUM(C3 C7) // returns #NULL!
In this case the input was meant to be the range C3:C7, but the colon did not get typed. Once the colon is added, the error is fixed:
=SUM(C3:C7) // returns 1205
Example 2 - space instead of comma
In the example below, the formula in C5 returns the #NULL error:
=SUM(C2,F2 I2) // returns #NULL!
Here, a space was typed instead of a comma between F2 and I2. Once the colon is added, the error is fixed:
=SUM(C2,F2,I2) // returns 1205