On Sheet 2

In Column A1 Enter =Sum(Sheet1!A1) etc...

Is this was what you are looking for?

Regard

--
drawling
-----------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...fo&userid=3662
View this thread: http://www.excelforum.com/showthread.php?threadid=57209