Countif with two conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column A has a number that corresponds to a month (i.e., 1-12), Column O has
a number from 0-5. I want a result that says that If column A has a one in
it, count the zeros in column O. In other words, I want to know how many
Zeros I get in each month.

A.............................O
1 1
1 0
1 0
2 0
2 2
2 1

The output should be that 1(Jan) has 2 zeros, and 2 (Feb) has 1 zero. What
is the formula to get that output?
 
typo Peo

=SUMPRODUCT(--(A2:A100=1),--(O2:O100=0))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
There was a typo

=SUMPRODUCT(--(A2:A100=1),--(O2:O100=0))


--
Regards,

Peo Sjoblom
 
Back
Top