Range Names

[wal50]

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.

 

[JE McGimpsey]

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.

 

[Toby Erkson]

You can use entire rows, just not columns, according to this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Toby Erkson
Oregon, USA
WindowsXP, Excel 2003

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.

....

 

[wal50]

Thanks. That was exactly what I was looking for. I was trying to use an
entire column because I will be adding rows. Sounds like I should just
define a large number.

wal50