Thread: [Solved] Countif returns 0 value
View Single Post
 
Old 02-07-2017, 12:57 PM
janielsean janielsean is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Feb 2017
Posts: 3
janielsean is on a distinguished road
Default 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
Reply With Quote