Hi Rusty
You can use countif with a wildcard e.g:=COUNTIF(A1:A500,"A*")
Adjust range and letter to your needs.
HTH
John
"Rusty" wrote in message
...
I have a column with employee code numbers. ie. A23,A34,A54,B43,B63,C23. They
are always a capital letter ans a 2 digit number. I need to build a formula
for a range that tells me how many employees there are that start with and
"A", a "B", a "C" and so on. Can someone help me with this? Thanks
--
rustyrunrite