help formular countif in excel!!!

[Nguyen Anh Dung]

help formular count column H. if begin is 9 then count. But in this case cell format is number or general then result not correct.
As picture below: i want result is column I2= 5
I2=3 is not correct.

Best regards,
Nguyen Anh Dung

 

[FormR]

Hi, you could select column H and choose "Data" > "Text to columns" > "Next" > "Next" > Choose "Text" in the "column data format" and click finish.

Or

You could try:

=SUMPRODUCT(--(LEFT(H2:H46)="9"))

 

[Nguyen Anh Dung]

Hi, you could select column H and choose "Data" > "Text to columns" > "Next" > "Next" > Choose "Text" in the "column data format" and click finish.

Or

You could try:

=SUMPRODUCT(--(LEFT(H2:H46)="9"))

Thanks you!!!