I'm using this formula on the sheet for the source of a chart.
I need to add 4 regions that have multiple cities.
How could I make named range hold multiple criteria to be validated in the sumproduct.
I'm trying to avoid typing every case.

=SUMPRODUCT(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd))
For example, the region "Leonard" has 4 offices: Modesto, Sacramento, Susanville, and Carson.
In Modesto there are 3 management areas: 1X, 1Z, and 3L

I have a chart source that has a list of results from all the areas.

I need to pull a sumproduct for all 3 ma's when I scan the Office:
=sumproduct(--(item01=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--(MA=1X OR 1Z OR 3L))
or (ma=1z),--(ma=1X),--(ma=3L)
or named range "modesto" contents: 1Z OR 1X OR 3L
datavalidation list named MAList

(ma=MaList)


I need to total all three MA values:
example values of:1z=3 1x=4 3l=3
ma=10


any suggestions

Mark