Sumproduct with OR-function

**Jonathan78** · 02-13-2012, 04:25 AM

Hello all,

I tried the follwoing but can't get it to work properly.
Can Sumproduct and OR-function be used together?

=IF($A$6="","",SUMPRODUCT((rep!$H$2:$H$500<$A$6)*SUMPRODUCT((OR(rep!$R$2:$R$500>$A$6,rep!$R$2:$R$500=""))*(rep!$M$2:$M$500=B24))))

**Pete_UK** · 02-13-2012, 04:35 AM

You can't use OR like that, but you can use + in the same way that * is interpreted as AND in these formulae with arrays. I'm not sure what you are trying to do, but maybe this:

=IF($A$6="","",SUMPRODUCT((rep!$H$2:$H$500<$A$6)*((rep!$R$2:$R$500>$A$6)+(rep!$R$2:$R$500=""))*(rep! $M$2:$M$500=B24)))

Hope this helps.

Pete