=SUMPRODUCT(--(LEFT(A1:A20,2)="11"))


--


Regards,


Peo Sjoblom


"Loralei" wrote in message
...
I have a range of cells with values that are 5 or 10 numbers long that
start
with 11, 12 or 13. What function do I use to tell Excel to count only the
cells which value starts with 11? I do not want to sum, only count the
number
of cells that have values starting with 11. Again, the values can be 5
digits, as in 11222 or 10 digits such as 1122222222. I only want Excel to
return the number of values that start with 11 regardless of how long the
digit actually is.