How to sum more then 31 worksheets cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thnak you Dear Valko, it help me to solve my problem. This i want
Thank you very much
Ahmad
 
Back
Top