Hi, I want to SUMIF the totals if the values are in the combination of 2 named ranges. Usually, for 1 named range I use the =SUMPRODUCT(SUMIF formula and it works fine.
Now that I have 2 named ranges I tried the SUMPRODUCT(SUMIFS formula without success.
Any ideas? See attached the test sheet with 2 named ranges + the desired result.
In red the values I want to be included in the sumif but are not being considered in the formula.
Thanks
Bookmarks