Not able to use a "><" on a COUNTIF formel

[sindre]

Having trouble with using "less than" and "greater than". Using this formula.
=COUNTIF(F:F;"<100")

It seems like it does not work due to the format of the numbers that I am working with. When I create a list with normal numbers, the formula work.

So, I have been trying to format these numbers, but I see no way out of this.

Screenshot: Image 2020-12-01 at 8.58.10 AM.png

 

[PhilipV]

It is clear from the screenshot that your entries in column F are not numbers but strings.
You have to make them real numbers in order to do calculations with them.

 

[AlphaFrog]

There are a couple methods to convert or coerce text-numbers into numeric values

Paste Special Multiply​

Text-to-Columns feature​

A formula in another column e.g. =F2*1​

​

Convert numbers stored as text to numbers​

​