First post: looking to troubleshoot using a name range in a multiple criteria sumproduct formula.
For instance, this formulas works fine:
but, when I try to substitute the two-alpha codes as a defined name range ("keys"), it errors as "N/A":Please Login or Register to view this content.
An example workbook is attached. Any thoughts?Please Login or Register to view this content.
Example Workbook.xlsx
Thanks in advance.
Bookmarks