MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.