CountIf not Equal to.
Formula looks right, assuming that you're trying to count cells only within
that range which meet your criterion, and that your criterion is to comprare
with the contents of C3, not with the string "G3".
What's the problem?
--
David Biddulph
"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
|