Example 1 - space instead of colon

In the screen below, the formula in C9 returns the #NULL error:

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:

Example 2 - space instead of comma

In the example below, the formula in C5 returns the #NULL error:

Here, a space was typed instead of a comma between F2 and I2.  Once the colon is added, the error is fixed:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

How to fix the NULL error Excel formula - 78How to fix the NULL error Excel formula - 54How to fix the NULL error Excel formula - 40How to fix the NULL error Excel formula - 58