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.