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.
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.