View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Jonathan Jonathan is offline
external usenet poster
 
Posts: 138
Default How do I count cells beginning with specific letter?

i think you mis understood, i need to know the number of first names in my
data, that begin with each particuliar letter of the alphabet, "A" through "z"

the number of occurances of each letter in the alphabet? A-Z

ex.

a 10
b 9
c 3
d 29


"Dave Peterson" wrote:

=countif(a1:b99,"a*")



jonathan wrote:

I have a nuber of cells that contain names, I have to count the names that
begin with with letter, a,through z, How do I do that?

"jay" wrote:

For example: I have a number of cells that contains names, and I have to
count the name that begins with letter "A", what do I do?

many thanks


--

Dave Peterson