-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules