This can be done with a worksheet function. Do you really want
macro?

see this application

http://www.xldynamic.com/source/xld.SUMPRODUCT.htm

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=56173