I've noticed some strange behavior using named ranges in some sumproduct formulas. I was under the impression that you could replace a range of cells with a named range and that should work without a problem, but, it appears that's not always the case.
For example, this works fine:
where the named range is another worksheet in the same workbook.
this does not work, returns #VALUE!
likewise, this works
but, if i replace one of the named ranges with the actual range, it does not work....
it's returns #N/A
any ideas as to why named ranges are not as versital as I'm thinking they should be?