| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
| Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
| Max value in same cell across ALL worksheets | Excel Worksheet Functions | |||
| Adding the same cell in different worksheets. Can that cell be variable? | Excel Worksheet Functions | |||
| Sum a cell within all worksheets | Excel Worksheet Functions | |||
Linear Mode
