# How to Fix the #NAME Error in Excel (3 Examples)

There are three common reasons why you may encounter the #NAME? error in Excel:

1. You mistyped a formula.

2. You left out a colon in a range reference.

3. You left out quotation marks for text values.

The following examples show how to fix each error in practice.

### Example 1: You Mistyped a Formula

Suppose we attempt to calculate the average value in column B using the following formula:

`=AVERAG(B2:B15)`

We will receive a #NAME? error since we mistyped AVERAGE in the formula: To correct this error, we simply need to make sure we spell the formula correctly:

`=AVERAGE(B2:B15)`

This time we’re able to successfully calculate the average value in column B without an error: ### Example 2: You Left Out a Colon in a Range Reference

Suppose we attempt to count the number of teams with a value of “Thunder” in column A using the following formula:

`=COUNTIF(A2A15, "Thunder")`

We will receive a #NAME? error since we left out a colon in the range reference: To correct this error, we simply need to make sure we include a colon in the range reference:

`=COUNTIF(A2:A15, "Thunder")`

This time we’re able to successfully count the number of teams with a value of “Thunder” in column A without an error: ### Example 3: You Left Out Quotation Marks for Text Values

Suppose we attempt to concatenate the values in column A and column B using the following formula:

`=CONCAT(A2, scored, B2)`

We will receive a #NAME? error since we left out quotation marks around “scored” in the formula: To correct this error, we simply need to make sure we include quotation marks around “scored” in the formula:

`=CONCAT(A2, " scored ", B2)`

This time we’re able to successfully concatenate the values in column A and column B without an error: 