SUMPRODUCT works with range names, but they need to conform to the
requirements of SUMPRODUCT's arguments - e.g., the ranges need to be of
equal size and can't be entire rows or columns.

Note that, in general, it's more likely you'll get a
correct/comprehensive answer to your question if you post the formula
that isn't working.


In article ,
"wal50" wrote:

Does Sumproduct work with range names or are there restrictions? Like no
blanks, etc. When I use range names I get #NUM

This is a very helpful group. I even figured out the last question myself
while I was waiting.