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.
