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