Counting in Excel

[Yee]

I have 2 list of data:

List A List B

A A
B A
C B
X
D


I want to count the number of occurances in List B which
reference in list A. So I should get the answer 3

Hope you understand what I mean. Many thanks
Cheers/Yee

 

[Leo Heuser]

Yee

One way:

=SUMPRODUCT(COUNTIF(ListB,ListA))

 

[Guest]

Leo
Great thanks

-----Original Message-----
Yee

One way:

=SUMPRODUCT(COUNTIF(ListB,ListA))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Yee" <[email protected]> skrev i en meddelelse


.

 

[Leo Heuser]

You're welcome, Yee.

LeoH

Leo
Great thanks

 

[Frank Kabel]

Hi
just an alternative approach: Use the following array formula (entered
with CTRL+SHIFT+ENTER):
=SUMPRODUCT(--(ListB=TRANSPOSE(ListA)))