countif and AND

K

kate

It should be so simple.... I am trying to get excel to
count the number of values for 2 conditions in a
worksheet. i.e. I want a count of the number of times the
value in column one = X AND the value in column 2 = Y. I
have tried various combinations of countif, count and AND
and have not been able to figure this one out. Excel help
is no use Any hints?
 
D

Dan E

Kate,

The SUMPRODUCT formula often helps for these
types of multiple criteria counts.
ie
=SUMPRODUCT((A1:A100="X")*(B1:B100="Y"))

Dan E
 
Top