Counting occurances

[lecxE]

Say I have column A filled with 10000 rows containing letters of the alphabet.

If I want a count of all the "J", "K", & "P" cells I could use:

=COUNTIF(A1:A10000,"A")+COUNTIF(A1:A10000,"B")+COUNTIF(A1:A10000,"C")

That works great.

What if I want to list values in column C and count the occurances of the values in column A. For example, in C1:C18 I'd like to put 18 letters of the alphabet and show the count in D1 of those letters that are in column A?

If there a better way the adding together 18 COUNTIF's?

Thanks.

 

[Jonmo1]

This should work

=SUMPRODUCT(--(ISNUMBER(MATCH(C1:C18,A1:A10000,0))))

Hope this helps...