Count cells with #N/A error

This tutorial shows how to count the number of cells in a specified range that contain an #N/A error using an Excel formula, with the COUNTIF function

EXCEL FORMULA 1. Count cells with #N/A error

EXCEL

Count cells with #NA error

=COUNTIF(B5:B10, "#N/A")
GENERIC FORMULA

=COUNTIF(B5:B10, "#N/A")

ARGUMENTS
range: The range from which to count the cells that contain an #N/A error.

EXPLANATION

This formula uses the COUNTIF function, with a criteria set to "#N/A", to count the number of cells that contain an #N/A error in the selected range.

In this example the range from which we are counting the total number of cells that contain an #N/A error is B5:B10, which contains a 2 cells with an #N/A error (B6 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

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