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)


"s boak" wrote in message
...
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 a 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