Thread: Need help building COUNTIFS solution
View Single Post
 
Old 02-26-2015, 12:45 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
There's probably a better way but at first blush this is how I would do it:

Add another column with the formula =WEEKDAY(A1,2), copy it down the sheet. Then your formula is:

Code:
=COUNTIFS(D:D,">5",C:C,"<>"&"")
or

Code:
=SUMPRODUCT((D:D>5)*(C:C<>""))
Reply With Quote