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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
need help on either doing a loop and counting specific values orusing subtotal function 2
CountIf with And 0
How to count a coloum if two conditions are met 5
using CountIF function or Array? 3
countif 3
Excel How to count from a column if specific condition in another column is true 3
Counting errors 5

Back
Top