Simple (?) Countif question

[LupeR]

I'm trying to automate the counting of people in a specific group, represented by their individual number. The first three numbers are their group, the last two numbers are their individual number. Each group is no larger than 40 people

My problem is every time I try something using 'countif' Excel returns a zero. I've tried the following formulas (syntax is approximate):

=countif(page!A:A,101**) -Error box popped up
=countif(page!A:A,"11**") -returned a zero
=countif(page!A:A,"10100<>10141") -again, returned a zero

How can I fix this?

Thanks in advance,
-Lupe

 

[Hui]

A3: =COUNTIFS('G1 Fall ''14'!A:A, ">10100",'G1 Fall ''14'!A:A,"<10141")

A4: =COUNTIFS('G1 Fall ''14'!A:A,">"&10100,'G1 Fall ''14'!A:A,"<"&10199)
is the same as 101??

A4: =COUNTIFS('G1 Fall ''14'!A:A,">"&11000,'G1 Fall ''14'!A:A,"<"&11999)
is the same as 11???

 

[azumi]

Perhaps something like this?