• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Fixing the #NAME? Error

In the cell you want to use as the resultant cell, type the formula you want to use in your calculation. For example, type =CNT(B3:B5) in cell B8 and press Enter.

In this case, you get the #NAME? error because CNT is not the correct spelling for the referenced function; it is COUNT.

Click on the resultant cell (here, B8), press F2 on the keyboard, and retype the formula—in this case, =COUNT(B3:B5)—and press Enter.

The error disappears because the function is spelled correctly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint