Is it possible to have an IF inside SUMPRODUCT?

Hi,

Is it possible to use an IF function within Sumproduct?

I am trying to create a formula that looks like this:

Sumproduct((RangeA)*if(A1=TRUE,RangeB,RangeC)*(RangeD))

The actual formula looks like this:

=SUMPRODUCT((Chart5DateAll<=EOMONTH(F$132,0))*IF(Chart5PeriodFiscalYTD=TRUE,OFFSET(Chart5DateAll,1,0)=OFFSET($F$104,0,MATCH(F$132,Chart5DateAll,0)-1),Chart5DateAll>EOMONTH(F$132,-Chart5PeriodIncrement))*OFFSET(Chart5DateAll,ROWS(F$103:F110)-1,0))

Problem is it works without the IF function.

Thanks,

Lawrence