Solved: Does sumproduct work with OR

[Shazam]

=sumproduct(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--(MA=1X OR 1Z OR 3L))

Mark

Do you mean this?

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


Hope it helps!