Learn, How to count the occurrence of a specific error in a Range of cells in Excel.
Follow beneath steps to Count the number of times a specific error appears in a range.
Select the entire range of cells, for which you want to take the count of error occurrence.
This is NOT an array formula.
A1:A5 is the range to check; change this to fit your data.
#NAME? is the error that you want to count. Change this to the desired error and make sure it is surrounded with quotation marks.
Result:
Follow beneath steps to Count the number of times a specific error appears in a range.
Select the entire range of cells, for which you want to take the count of error occurrence.
=COUNTIF(A1:A5,"#NAME?")
This is NOT an array formula.
A1:A5 is the range to check; change this to fit your data.
#NAME? is the error that you want to count. Change this to the desired error and make sure it is surrounded with quotation marks.
