I have a column in another sheet called Ranking (Text/Number field). It contains numbers from 1-200. Using this formula it's returning a value of 0 which is not accurate from the column I selected. Is there something I'm missing?
=COUNTIF({Ranking}, >100)
I even tried to complete the formula in the sheet directly and it's displaying 0 which isn't correct.
=COUNTIF(AMLAW:AMLAW, >100)
Any help would be great.