View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I count cells beginning with specific letter?

=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