![]() |
#2
|
||||
|
||||
![]()
Try
Code:
=SUMPRODUCT((WEEKDAY(A2:A6)>5)*(C2:C6<>""))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
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 |
![]() |
Algo | Excel | 6 | 11-13-2012 07:44 AM |
countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |