Solved: Does sumproduct work with OR

[mperrah]

We Got IT!
Thank you Bob!
Re-reading post 18 said values can't be in same cell.
I put each value in a different cell and named that range.
plugged the name in the sumproduct and presto.
Now I made a named range for each office,
and typed the names of each of those named ranges
into another range named MAList
then made a dataVal list with the name MAListChoice
in sumproduct is the MAListChoice:
[vba]=SUMPRODUCT(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--(ISNUMBER(MATCH(MA,MAListChoice,0))))[/vba]

You are awesome!!!

Sorry again about the small font

I got ahead of myself,
The named range of the named range doesn't calculate
If I code the MAListModesto in the sum product it works,
but if I have a DataVal list with MAListModesto as the picked choice it does not work.
I tried:
[vba]=SUMPRODUCT(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--(ISNUMBER(MATCH(MA,MAListChoice,0))))

and
=SUMPRODUCT((item01=scan_item)*(QCDate>=chStart)*(QCDate<=chEnd)*(ISNUMBER( MATCH(MA,MAListChoice,0))))

and
=SUMPRODUCT((item01=scan_item)*(QCDate>=chStart)*(QCDate<=chEnd)*(MA=MAList Choice))[/vba]

How can I make a list to choose from to input the picked values for the sumproduct?