Trying to count the errors on the sheet

Samuel Dowdy Jr.

=COUNTIF(Location:Location, "NO MATCH")

Instead of getting a number im getting #NO MATCH.

Christian G.

You can catch the error and change it to a string that can then be used with a match.

=Iferror([your match formula here],"NO MATCH")

Then:

=COUNTIF(Location:Location, "NO MATCH")

Keep in mind that this will change ALL errors to "no match", Event the "#Invalid Data type" that we see here