Range Names
 

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.

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.

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


"JE McGimpsey" wrote in message
...
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.
....

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

"JE McGimpsey" wrote:

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.