MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF based on two separate criteria


Posted by Jeff on January 09, 2002 7:42 AM

I need to Countif anything in column A = criteria1, AND column B=criteria2... How do I do this? Any ideas?
If both pieces are true, I need to count that row


Posted by Juan Pablo G. on January 09, 2002 7:46 AM

=SUMPRODUCT((A1:A100=Criteria1)*(B1:B100=Criteria2))

Juan Pablo G.

Posted by Jeff on January 09, 2002 7:52 AM

Got #NAME? The criteria is alphanumeric, and I need it to count the occurrences... did I miss something?

Posted by Juan Pablo G. on January 09, 2002 7:55 AM

How did you paste the formula, in other words, can you paste your formula ?

Juan Pablo G.