Forum Discussion
I'm trying to count records between a start and finish date, with another text based criteria
I'm trying to count records between a start and finish date, based, with another text based criteria. I have a series of annual contracts with a start and finish date. I want to be able to select an...
=SUMPRODUCT((B$1=Sheet1!$C$2:$C$24)*(Sheet1!$A$2:$A$24<=Sheet2!$A2)*(Sheet1!$B$2:$B$24>=Sheet2!$A2)*(Sheet1!$D$2:$D$24="valid"))Does this return the expected result?