Hi!

I have a very big workbook containing 52 identical worksheets.
Plus Summary sheet in the same workbook identical to all worksheets.
I need a formula that will summarize every single cell all over the
worksheets. Something like consolidate but within the sheets in one
workbook.

For example:
=Sheet1!A1+Sheet2!A1+Sheet3!A1

I can't use this simple formula as:
1. Too many sheets
2. Sheet names are long
3. Formula becomes very big

Is there any other function that will make it?

Thanks in advance for your help.
Irada


--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile: http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=381871