Using Countifs on the same Column Multiple Times
Posted on 2013-01-16
Is it possible to use Countifs in this way:
I would like to count X if A is true and B is true or C is true or D is true or E is true .
B, C, D, and/or E are all in Column O. A is in column P
So essentially I'm looking for a way to make the formula work with:
Countifs(P:P, "variable A", AND O:O, "variable B", OR O:O "variable C", OR O:O, "variable D") etc....
If not, what can I use to accomplish?