How to sum more then 31 worksheets cell

[Guest]

My one Excel file have 31 worksheet i want Cell A1 data of all 31worksheet in
one worksheet with sum furmula (Summery worksheet) sum of all 31 worksheet
cell A1 data in my summrey cell. i know only with + Exp
=SUM('(1)'!B5+'(2)'!B5+'(3)'!B5+'(4)'!B5+'(5)'!B5+'(6)'!B5) till 31 worksheet
I WANT SUM WITH RANGE

Thank you

 

[T. Valko]

Are all these sheets in sequential order? If so try this:

=SUM('(1)31)'!A1)

Or, you can create a worksheet "sandwhich". Create an empty sheet named
Start and place it to the left of sheet (1). Create another empty sheet
named End and place it to the right of sheet (31). Then use this formula:

=SUM(Start:End!A1)

Any sheets within the "sandwich" will be included in the sum.

Or, this:

=SUMPRODUCT(N(INDIRECT("'("&ROW(INDIRECT("1:31"))&")'!A1")))

Biff

 

[Guest]

Thnak you Dear Valko, it help me to solve my problem. This i want
Thank you very much
Ahmad

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thnak you Dear Valko, it help me to solve my problem. This i want
Thank you very much
Ahmad

 

[Narasimharao l mynampati]

You're welcome. Thanks for the feedback!

Biff