| 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 |
| 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 | |||
Threaded Mode
