Formulas

How to fix the #NAME error in Excel?

Pinterest LinkedIn Tumblr

The #NAME error in Excel occurs when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula.
This error would have been noticed several times and this can appear for various reasons, the most common being misspelled formula.

For Example, the #NAME error in Excel occurs when Excel does not recognize text in a formula when the formula is misspelled. As you can see in the Master data provided with the list of items with their price. when you need to find the sum of the total price, hereby entering incorrect formula name as given below for the table underneath.

=SU(C7:C11)

#NAME error in Excel

How to Fix #NAME error in Excel?

To resolve this error, check the formula’s spelling, or use the Formula Builder to have Excel build the function for checking. If the formula is spelled correctly, and your spreadsheet is still returning an error, Excel is probably getting confused over one of your entries inside the formula. An easy way to fix this is to have Excel insert the formula by itself. By correcting the formula name from SU to SUM the error is rectified.

=SUM(C7:C11)

To know more about all the major MS Excel errors, please refer to our Article on Errors.

You can view our videos available on our Youtube channel to enhance and refresh your Excel knowledge.

Related Posts

Write A Comment