Countif returns 0 value

[janielsean]

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

[xor]

Try

=SUMPRODUCT(--(--(LEFT(A2:A10,3))=120))

[janielsean]

Thanks xor, tried it nothing happened but "#value!" error...

Originally Posted by xor

Try

=SUMPRODUCT(--(--(LEFT(A2:A10,3))=120))

[xor]

Take a look here.

[janielsean]

Originally Posted by xor

Take a look here.

thanks xor, it seems the values in each cells were not recognized by the formula somehow, I manually entered the numbers and the formula works just fine....

thanks much...

Jan