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