Conditional Count

[DC]

I am trying to do a count based on several conditions. I tried using the conditional sum wizard and change the code from sum to count, but it gives me a count of the entire range. Any ideas on limiting a count based on conditions being met by other columns?

[Juan Pablo González]

Assuming your data looks "similar" to this:

{"a",1,3;

 "b",2,3;

 "c",1,4;

 "d",2,4}

And you want to count the letters in the first column that have a 1 in second column and a 3 in third column, try this formula:

=SUMPRODUCT((B1:B4=1)*(C1:C4=3))