Thanks. Both approaches worked but when I inserted a column in one of
the team worksheets I noticed the mentioned equations did not return
the correct result because it referred to a fixed cell in the team
worksheet.


--
Cincy
------------------------------------------------------------------------
Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=563010