# SumProduct w. Multiple Criteria Question

#### lawre2000

##### Board Regular
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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Colin Legg

##### MrExcel MVP
Here's one way (untested):

Code:
``````=-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

##### Board Regular
Works great, thanks!

Replies
3
Views
700
Replies
16
Views
740
Replies
1
Views
172
Replies
6
Views
312
Replies
1
Views
246

1,195,949
Messages
6,012,483
Members
441,701
Latest member
vnkendijs

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back