Logic search using countif

Posted by kevin wiliams on December 12, 2001 8:41 PM

I want Excel to count the number of times "AI" appears in column C when "loop" appears in column F. I can count them seperately by using the following formulas, =countif(c1:c10,"AI"). Or I can use
=counif(f1:f10,"loop"). How can I search both at the same time?

Posted by Juan Pablo G. on December 12, 2001 8:48 PM

Is this what you want ?

=SUMPRODUCT((C1:C10="AI")*(F1:F10="loop"))

Juan Pablo G.