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.