COUNTIF or SUMIF Problem

S

s boak

Hi folks:

I have a Bill-of-Materials where the parts used in a product are referenced
like C11, R22, etc.

The contents of C2 are: C13,C16,C18,C19,C23

To get a quantity of the parts used of each type, is it possible to count
the occurences of "C" (or R, or anything else) ?

I've tried =COUNTIFSheet1!,"*C*" and variants

Would appriciate any help - Many thanks

Steve
 
B

Bob Phillips

Have you tried

=COUNTIF(Sheet1!A:A,"*C*")

where A is the column with the data in

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

Jason Morin

If the part numbers are listed in several cells (ie 1
part number per cell), then you've got it:

=COUNTIF(A1:A5,"*C*")

But if parts are listed in *one* cell with a comma
delimiter, then use:

=LEN(A1)-LEN(SUBSTITUTE(A1,"C",""))

HTH
Jason
Atlanta, GA
 
Top