count cells with "<"

[TimB]

I want to use the countif function to count the number of cells with contents starting with a "<" (e.g., <2.2)

I have tried =countif(range,"<*")

but does not work.

Thanks
Tim

[VBA Noob]

Try

=COUNTIF(A:A,"*<*")

VBA Noob

[daddylonglegs]

for specifically < as first character try

=COUNTIF(range,"~<*")

[TimB]

After spending quite a bit of time on this, that was embarassingly simple.

Thank you!

Tim