Help with CountIF formula

[Smonczka]

Hello All,

Is there a way to use CountIF to count any cells with a particular
number or letter in the cell? I am trying to count the types of parts
we have. Each type of part starts with a particular letter. So one
type of parts might start with a "P", i.e. P105064 or P646546 or
P797985 and another might start with "T", i.e. T1266465, T879646 or
T8646377. What I need to do is count the number of different types of
parts. Is there a way to count if a cell value contains a "P"?

Thanks for all the help.

Steve

 

[Don Guillett]

=SUMPRODUCT((LEFT(D24,1)="p")*1)
or for both p & t
=SUMPRODUCT((LEFT(D24,1)={"p","t"})*1)

 

[Dave Peterson]

Starts with a P:
=countif(a1:a10,"P*")

Contains a P:
=countif(a1:a10,"*P*")

 

[Smonczka]

My thanks to both of you!