countif and AND

  • Thread starter Thread starter kate
  • Start date Start date
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?
 
Kate,

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

Dan E
 
Back
Top