Count If Column A = x and Column B = y
Awesome, this worked great -- can you use if for more than two conditions?
"Teethless mama" wrote:
=SUMPRODUCT((A1:A100="x")*(B1:B100="y"))
"Trish" wrote:
I am trying to use the count function where two conditions in different
columns need to be satisfied and having no luck. Basically I want to look in
the first column to see if it's A, then look in 2nd column to see if it's B,
then count it... is that possible?
|