Quote Originally Posted by civ1979 View Post
That doesn't work for some reason. Example: File 'dft' has one date itself with greater than thr return result with that formula of 26 days. Row 20 dates for 'dft' are 2/25-3/28 which is 32 days itself. So that plus the other non overlapping date in row 10 of 7/10-7/10 should have resulted in the total days being 33.

Mine comes up with 34 for that one. Array-entered.
Formula: copy to clipboard 
=SUM(IF(MMULT((ROW(INDEX(A:A,MIN(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$B$2:$C$21))):INDEX(A:A,MAX(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$B$2:$C$21))))>=TRANSPOSE(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$B$2:$B$21)))*(ROW(INDEX(A:A,MIN(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$B$2:$B$21))):INDEX(A:A,MAX(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$C$2:$C$21))))<=TRANSPOSE(IF(Sheet1!A2=Sheet2!$A$2:$A$21,Sheet2!$C$2:$C$21))),SIGN(ROW(Sheet2!$A$2:$A$21))),1))
Applying filters to Sheet2 I come up with same. What am I missing?