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
 

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

need help on either doing a loop and counting specific values orusing subtotal function 2
How to count a coloum if two conditions are met 5
Excel How to count from a column if specific condition in another column is true 3
Counting errors 5
Count rows based on multiple criteria 3
COUNTIF Function 4
Finding the weighted average of text that have been given values 1
Excel Need Countifs Formula Help 0

Top