How to sum more then 31 worksheets cell
 

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

How to sum more then 31 worksheets cell
 

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

"Qazi Ahmad" wrote in message
...
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

How to sum more then 31 worksheets cell
 

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

"T. Valko" wrote:

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

"Qazi Ahmad" wrote in message
...
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

How to sum more then 31 worksheets cell
 

You're welcome. Thanks for the feedback!

Biff

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

"T. Valko" wrote:

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

"Qazi Ahmad" wrote in message
...
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

How to sum more then 31 worksheets cell
 

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

Biff

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

"T. Valko" wrote:

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

"Qazi Ahmad" wrote in message
...
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