Your formula looks fine. What results are you seeing?

"Pendelfin" wrote:

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