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

EXCEL FORMULA 1. Count cells with #NAME? error

EXCEL

Count cells with #NAME error

=COUNTIF(B5:B10, "#NAME?")
GENERIC FORMULA

=COUNTIF(B5:B10, "#NAME?")

ARGUMENTS
range: The range from which to count the cells that contain an #NAME? error.

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
How to count the number of cells in a specified range that contain errors
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
The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria