what is the #name error in excel?
The formula refers to a name that has not been defined When your formula has a reference to a name that is not defined in Excel, you will see the #NAME? error. See the following example of a SUM function referring to Profit, which is an undefined name in the workbook.