Count cells with #NAME? error
This tutorial shows how to count the number of cells in a specified range that contain an #NAME? error using an Excel formula, with the COUNTIF function
|
=COUNTIF(B5:B10, "#NAME?")
|
GENERIC FORMULA
=COUNTIF(B5:B10, "#NAME?")
ARGUMENTS EXPLANATION This formula uses the COUNTIF function, with a criteria set to "#NAME?", to count the number of cells that contain an #NAME? error in the selected range.
In this example the range from which we are counting the total number of cells that contain an #NAME? error is B5:B10, which contains a 2 cells with an #NAME? error (B7 and B9). |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Count cells with errors | How to count the number of cells in a specified range that contain errors | |
| Count cells with #N/A error | How to count the number of cells in a specified range that contain an #N/A error |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| COUNTIF Function | The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria |