Assuming totals were in cell a1 in all three sheets

In sheet 2

=sum(sheet1!a1+a1)

In sheet 3

=sum(sheet1!a1+sheet2!a1+a1)



Hope this helps


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=375980