View Single Post
 
Old 02-26-2015, 11:11 AM
676nova 676nova is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Feb 2015
Posts: 3
676nova is on a distinguished road
Default 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
Reply With Quote