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:

<pre>
{"a",1,3;
"b",2,3;
"c",1,4;
"d",2,4}
</pre>

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))