Solved: Does sumproduct work with OR

[RichardSchollar]

Shazam
I get a value error with this method
I tried with and w/o cse (ctrl+shft+enter)

btw
I grew up watching the TV show Shazam, any connection?
Mark

Hi Mark

Are you sure that all your named ranges are the same size?

Richard

EDIT: They aren't the same size as the result of the last argument produces an array 3 'columns' wide - so, as Bob shows, you need to use the multiplication operator *. Or perhaps:

=sumproduct(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--ISNUMBER(MATCH(MA,{"1X","1Z","3L"},0)))