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.
....