Counting Items with extra letter

[dragonmouse]

I'm looking for the "simplest formula" to count serial numbers that may have an extra letter at the end:

12345
23456
45678
45678A
45678B
57198
67895
59876A
89756
98756

Even though there are 10 serial numbers, I ONLY want to count those with a "letter" in them. (my answer would return 3). In a nutshell I have a thousand numbers and I'm trying to separate out those numbers that are real jobs and those that are subjobs and simply return a COUNT on a second "summary" worksheet. Any ideas?

 

[Rick Rothstein]

Assuming the cells are formatted as General so that the numbers without letters are real Excel numbers...

=COUNTA(A1:A100)- COUNT(A1:A100)

Change the two ranges to match where your data actually is located at (note, you can specify a larger range if you cannot be sure where the end of the data might be).

 

[dragonmouse]

Thank you so much. That worked great. Exactly what I needed.