Appologies to All, I missed read the result and thought it had only removed
1 number from the total count of rows. The formula is working ok.
Appologies again

"E-Coder" wrote:

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