it sounds like the sumproduct function can do what you want

check this out and see if it will do what you need - it does wor
across (even closed) worksheets.

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=55071