1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • CountIF not working on Formula ?

    From Shaun C@21:1/5 to All on Wed May 11 20:07:23 2022
    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")

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alex Plantema@21:1/5 to All on Mon May 30 14:04:28 2022
    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)