Sumproduct with And and OR

[DerekWooley]

Hello, I am using excel 2003 and would like to know if the below formula has any issues with it because I keep getting the #Value ! error and I'm not sure why.

Below is my formula.

I want the first two to be OR which is why there is a + sign between the. and the others are all * for AND.

=SUMPRODUCT(((Adjustments!$E$9:$E$10000="WIP")+(Adjustments!$E$9:$E$10000=B162))*(Adjustments!$B$9:$B$10000='Runout Calculation+Prev Run Qty'!B162)*(Adjustments!$N$9:$N$10000>L162)*(Adjustments!$N$9:$N$10000<>0)*Adjustments!$H$9:$H$10000)

<tbody>
</tbody><colgroup><col></colgroup>

 

[DerekWooley]

Thank you very much. That works perfectly!

 

[Aladin Akyurek]

Thank you very much. That works perfectly!

You are welcome.