try
=SUMPRODUCT((LEFT(J2:J5)="a")*1)

--
Don Guillett
SalesAid Software

"jay" wrote in message
...
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