say if you want to sum cell range from a1:a4 in all the sheets and have
the result in c10.

you can use formulae in c10 as
=SUM(Sheet1!A1:C4)+SUM(Sheet2!a1:a4)+SUM(Sheet3!a1 :a4)+SUM(Sheet4!a1:a4)+.......


where Sheet1 , Sheet2 ..... are the sheetnames for which you want to
totalup values


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=373982