A sumproduct would be more suited to your needs I think but without more
details it's hard to tell. Give more details of your setup like
spreadsheet names, ranges of your data, stuff like that and I'm sure
you'll get an answer to your problem.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=499250