Thanks Max but this returns the wrong amount. I am aiming for a figure of 47
but this is obviously going to change when i amend the data. This gave me 67.
I have tried another formula:

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

but this includes blank cells which i do not want included and gives me a
sum of 84. Any ideas?

"Max" wrote:

One way
Assume source range to be checked is A2:A10
In B2: =COUNTA(A2:A10)-SUMPRODUCT(--ISNA(A2:A10))
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"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?