Thanks to all, especially Bob, you da man
I went with post #7

What I plan to do is make a named range with the ma #'s spelled out for each office, then have a drop down validation list that gets called from the sumproduct
ie: named "modesto" range: (MA="1X")+(MA="1Z")+(MA="3L")
named "office" dataval: modesto, sac...
=sumproduct(.....(Office)
Trying this is not working (Value error)
I have 23 offices and need a way to input the different MA numbers
into the sumproduct

Post 7 is how the result needs to work, how can I store each group and use a named range in the sumproduct?