You didn't say what the problem was. I assume it was counting blanks as
numbers
try
=SUMPRODUCT((C2:C22<G3)*(ISNUMBER(C2:C22)))

--
Don Guillett
SalesAid Software

"Pendelfin" wrote in message
...
Please can someone give me a clue as to where I am going wrong with the
following formula.

=COUNTIF(C2:C3863,"<"&G3)

I want to count in column C all thee cells that do not equal G3.

Many Thanks in advance