how to count first number in 5 digits in a column

[fayez_MrExcel]

How to count employee number that starts with 1 in a column. I have 5 digits employee number in column a1:a100

 

[Aladin Akyurek]

How to count employee number that starts with 1 in a column. I have 5 digits employee number in column a1:a100

If emp numbers are text...

=COUNTIF(Range,"1*")

Otherwise:

=SUMPRODUCT((LEFT(Range)+0=1)+0)

 

[Jonmo1]

If they are all 5 digit #s, this should work...

=SUMPRODUCT((A1:A100>=10000)*(A1:A100<20000))

 

[Peter_SSs]

Possibly this?

Excel Workbook
	A	B	C	D
1	Employee Number		Count Starting with 1	5
2	12345
3	15698
4	14568
5	26598
6	35742
7	11111
8	35560
9	15790
10
Count Employee Numbers