Need help building COUNTIFS solution
Column A = dates, Column C = text data (either blank, N, P, or C). I would like to count the number of occurrences where column A is a Saturday or Sunday *AND* when column C is not blank.
Col A Col C
1/10/15 P
1/31/15 C
3/1/15
4/3/15 N
4/4/15 P
In the example above, the answer would be 2 as row 1 and row 4 would meet both criteria
|