All,
I have the following array formula:
=SUM(IF(FREQUENCY(IF($A$2:$A$14<>"",IF($B$2:$B$14=$F2,
    IF($C$2:$C$14=G$1,MATCH("~"&$A$2:$A$14,$A$1:$A$14&"",0)))),
      ROW($A$1:$A$14)-ROW($A$2)+1),1))
However when I try and make it the following formula:
=SUM(IF(FREQUENCY(IF(Data!$A$2:$A$955<>"",IF(Data!$F$2:$F$955="SCM",
 IF(Data!$M$2:$M$955="Passed",IF(Data!$H$2:$H$955>=B1,IF(Data!$I$2:$I$955<=C1,MATCH("~"&Data!$A$2:$A$955,Data!$A$1:$A$955&"",0)))))),
      ROW(Data!$A$1:$A$955)-ROW(Data!$A$2)+1),1))
So basically I added the following line:
,IF(Data!$H$2:$H$955>=B1,IF(Data!$I$2:$I$955<=C1

B1 and C1 are dates so I'm just comparing if it's in between these dates. Any ideas why my second formula produces an error?

Thanks in advance.