Need Help Wih COUNTIFS using WS Funtion in criteria

[PosseJohn]

I have a WS that I need to count the number of entries in a column which start with "<=" and "<".

I have tried the following:
=COUNTIFS(F5:F500,LEFT(F5,2)="<=",F5:F500,LEFT(F5,1)="<")

An example of my data looks like:
<=5.001
8.422
<6.455

[Jonmo1]

You can't apply a function to manipulate the criteria range in countifs.

Try wildcards

=COUNTIF(F5:F500,"<=*")

[jason.b75]

This should do what you need.

=COUNTIF(F5:F500,"~<*")

edit:-

Note to admin, I advised the OP to start a duplicate thread via PM as the original thread is returning database error.

http://www.excelforum.com/excel-form...-criteria.html

[Ace_XL]

Or maybe..

=SUMPRODUCT(--(LEFT(F5:F500)="<"))