Hi there,

I have two lists of names (col A, names can reappear) which are
classissified as either A or B entries in col B.

I need to know a) which names of list 1 appear on list 2 and b) how
often they appear on list 1 and list 2 and c) how many of the entries
on list 1 are A-entries, finally d) how many are B-entries, then e)
the same for list 2.

I already figured a) and b), while d) and e) will be corollary to c)
so I should be able to do them after I (please) can get help on c)
where I am at a complete loss.

CountIf allows me only to count the entries based on one conditionand
I can't find  a function which accepts two conditions.

Thanks
Knud