Op do 12-05-2022 om 05:07 schreef Shaun C:
i have some data in F2 to F22, all references different values on another sheets tab ex: =JSON!U15
the result is 50 in the cell, but the formula below is showing zero
=COUNTIF(F2:F22,"<20")
50 is greater than 20 so it doesn't count,
and if the referenced cells contain numbers stored as text they won't be counted either.
--
Alex.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)