Help with CountIF formula
 

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

Help with CountIF formula
 

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

--
Don Guillett
SalesAid Software

"Smonczka" wrote in message
oups.com...
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

Help with CountIF formula
 

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

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




Smonczka wrote:

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

--

Dave Peterson

Help with CountIF formula
 

My thanks to both of you!