Countif returns 0 value
I have a range of numbers in a column (example below)
I tried =COUNTIF(A2:A9,"120????") and it returned a zero result,
I want to count how many cell value starts with 120
1202616
1201925
805230
630154
1103057
1202559
1156971
1201577
1163681
thanks
|