View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

=COUNTIF(A1:J100,"A*")

In article ,
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