double conditions for CountIf

K

Knud Gentz

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
 
B

Bob Phillips

Don't understand your data layout, but you can use

=SUMPRODUCT(--(rng1="val1"),--(rng2="val2"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bucky

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

I couldn't follow your example, but for the above requirement, you can
create another (hidden) column to handle the logic conditions, then do
countif on the hidden column where TRUE.
 
Top