sum if w/ frequency, len, match, & left functions

[g17]

hi. i wanted to add another IF condition to an existing formula but it's giving me an N/A result.

original formula:

=SUM(IF(FREQUENCY(IF(LEN('Raw Data'!$A$2:$A$864)>0,MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""),IF(LEN('Raw Data'!$A$2:$A$864)>0,MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""))>0,1))

i need to add this condition:

IF(LEFT('Raw Data'!$C$2:$C$864,7)="2011-10")

i tried this:

{=SUM(IF(LEFT('Raw Data'!$C$2:$C$864,7)="2011-10",IF(FREQUENCY(IF(LEN('Raw Data'!$A$2:$A$864)>0,MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""),IF(LEN('Raw Data'!$A$2:$A$864)>0,MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""))>0,1)))}

no luck. please help. tnx.

 

[GlennUK]

Would it be:

=SUM(IF(FREQUENCY(IF(LEN('Raw Data'!$A$2:$A$864)>0,IF(LEFT('Raw Data'!$C$2:$C$864,7)="2011-10",MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""),""),IF(LEN('Raw Data'!$A$2:$A$864)>0,MATCH('Raw Data'!$A$2:$A$864,'Raw Data'!$A$2:$A$864,0),""))>0,1))