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
"=-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