COUNTIF function

[gkelle]

I have a long list of model numbers in column A with some blank cells in
the column. I got the total model count using COUNTA to skip blanks.
I would now like to find out of all models how many are a specific
brand. The first letter is "A" for one type "J" for another etc.

I tried COUNTIF(A2:A4000, LEFT(A2:A4000,1)="A")
but LEFT is looking for a single cell not a range

Is there any way say LIKE A*

Any suggestions would be appreciated.

 

[JE McGimpsey]

One way:

=COUNTIF(A2:A4000,"A*")

 

[Trevor Shuttleworth]

=COUNTIF(A2:A4000, "A*")

Regards

Trevor

 

[Frank Kabel]

Hi
try
=COUNTIF(A2:A4000,"A*")

or
=SUMPRODUCT(--(LEFT(A2:A4000,1)="A"))

 

[gkelle]

Thanks everyone, that works for m