SumProduct w. Multiple Criteria Question

[lawre2000]

All, I have the following SumProduct formula that provides results on multiple criteria being met in multiple columns:

"=-SUMPRODUCT('[SWU Fcst 111108.xls]Mktng Inputs'!$D$2:$D$300,--('[SWU Fcst 111108.xls]Mktng Inputs'!$A$2:$A$300=DATE(I$3,I$1,I$2)),--('[SWU Fcst 111108.xls]Mktng Inputs'!$B$2:$B$300=$A140),--('[SWU Fcst 111108.xls]Mktng Inputs'!$D$2:$D$300>0),--('[SWU Fcst 111108.xls]Mktng Inputs'!$R$2:$R$300=1))*1000"

The formula works fine as it is currently however I wanted to expand on the criteria in green font. What I was hoping to do is have the criteria say if Column R = 1 or Column S = 1. I am familiar with the OR function but can not find the right combination to make it work correctly. Any thoughts would be greatly appreciated. Thanks

 

[Colin Legg]

Here's one way (untested):

=-SUMPRODUCT('[SWU Fcst 111108.xls]Mktng Inputs'!$D$2:$D$300,
    --('[SWU Fcst 111108.xls]Mktng Inputs'!$A$2:$A$300=DATE(I$3,I$1,I$2)),
    --('[SWU Fcst 111108.xls]Mktng Inputs'!$B$2:$B$300=$A140),
    --('[SWU Fcst 111108.xls]Mktng Inputs'!$D$2:$D$300 > 0),
    --((('[SWU Fcst 111108.xls]Mktng Inputs'!$R$2:$R$300=1)+('[SWU Fcst 111108.xls]Mktng Inputs'!$S$2:$S$300=1)) > 0))*1000

 

[lawre2000]

Works great, thanks!