If you mean count the ** number of cells ** then try

'if you mean the error #N/A try
=COUNTIF(A1:A10,"<#N/A")

'if you mean text n/a
=COUNTIF(A1:A10,"<N/A")

If this post helps click Yes
---------------
Jacob Skaria


"OEMJ" wrote:

Hi, I am trying to create a formula which counts the number of cells in a
column range which do not equal "n/a". I am at a total loss...any suggestions?