Thanks. It works perfectly!!!
"daddylonglegs" wrote:
I'd use SUMPRODUCT but either way you can't use complete column refs
like A:A - switch to A1:A1000 or similar
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512636