I think I have discovered the winning formula...

=COUNTA(N4:N107)-COUNTIF(N4:N107,"n/a")

This returns the correct result but does it make sense?


"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?