|
|
#1
02-26-2015, 11:11 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| COUNTIFS Help Needed | OTPM | Excel | 2 | 04-09-2014 08:32 AM |
| Building blocks show correctly in dropdown, but wrong building block populates in doc | wordgirl123 | Word | 0 | 10-03-2013 08:30 AM |
| Compound Countifs Query not working | Lonercom | Excel | 5 | 06-28-2013 10:27 AM |
 Countifs and Sumproduct
|
Algo | Excel | 6 | 11-13-2012 07:44 AM |
| countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |
Mac OS X 
Office for Mac 2011
Threaded Mode