Wednesday, January 18, 2017

Count Specific Errors in excel

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.
 =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.



Result:
 



No comments:

Post a Comment