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

Count Number of Unique Cells That Don't Have Certain Characters 0
Using <= in countifs statement 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel 2010 countifs for date range 3
Simple COUNTIF function help 3
Finding the weighted average of text that have been given values 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
countifs Function not giving desired result with date criteria 2

Top