Multiple criteria for Countif
Posted by Tom Boyd on January 07, 2002 2:23 PM
I am trying to chart a baseball schedule. How do I handle a countif with multiple criteria? For example:
A B C D
1 05/30/02 Game1 Home Weekday
2 05/31/02 Game2 Away Night
3 06/01/02 Game3 Home Weekend
4 06/02/02 Game4 Away Weekend
=COUNTIF(B1:B4,"home") gives me 2
=COUNTIF(C1:C4,"weekend") gives me 2
How do I get a count of games that are both "home" AND "weekend"? BTW, my data ranges will be done by month.
Thanks in advance!