Excel VBA Count #N/A Errors

How to count number of #N/A error in Excel?

Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,”#N/A”)

Consider, You havefew vlookup formula in column D.

Out of it, few resulted in #N/A error. To get the count of this error in column D use the below formula or macro code.

'-Use this formula in any Excel cell
=Countif("D:D","#N/A")

'-Use this command in VBA Code
MsgBox Application.CountIf(Cells, "#N/A")

Both the above function gives the same result.

Not only count, You can also delete or highlight all the #N/A errors using the VBA code in this page.