Use the space as the intersection operator. Type the defined name, a space
and then click the column header. This will give you only the "current"
column.

--
Kind regards,

Niek Otten

"soteman2005"
wrote in message
...

Hi,

I have been using range names for each row in my worksheet and now I am
trying to use sumproduct but I can't get it to work using the range
names as it takes the entire range, not just the current column. I
have rangenamed by columns as well so I tried using those to define it
but with no success...any help would be great, maybe a UDF could do
it??


--
soteman2005
------------------------------------------------------------------------
soteman2005's Profile:
http://www.excelforum.com/member.php...o&userid=29078
View this thread: http://www.excelforum.com/showthread...hreadid=510528