countif function

[billy]

Hope someone can help me.

I have a range of cells A1..A50 containing six digit
number series, I wan to count the number of cells in the
range that start with 64xxxx. I tried Countif
((a1:a50,left2),64). But does not work..

 

[Frank Kabel]

Hi
try
COUNTIF(A1:A50,"64*")

 

[Norman Harker]

Hi Billy!

Try!

=SUMPRODUCT(--(INT($A$1:$A$10/10000)=64))