Home |
Search |
Today's Posts |
#1
|
|||
|
|||
summing values for the same cell in 36 different worksheets
Workbook=37 worksheets
Sheet 1 is a summary sheet I know how to add cells from all worksheets (2 -37) back to the summary sheet 1(Sheet2!c3+Sheet3!c3)...all the way to Sheet 37 This is very manual. I need to perform this same function for 106 cells. Is there a way to set up a range of the same cell from multiple worksheets?? I tried "sheet2!c3:sheet37!c3" to add all c3 cells from sheets 2-37 back to sheet 1. Didn't work. |
#2
|
|||
|
|||
MJ,
=SUM(Sheet2:Sheet37!C3) which can then be copied down or over, etc. But the next time you set up a workbook, use one sheet with an extra column where you enter a value that differentiates the entries (perhaps listing what would be different among your 36 worksheets). Then, you'll be able to use filters, SUBTOTAL functions, and pivot tables, and not worry about 3D formulas. HTH, Bernie MS Excel MVP "MJoyner" wrote in message ... Workbook=37 worksheets Sheet 1 is a summary sheet I know how to add cells from all worksheets (2 -37) back to the summary sheet 1(Sheet2!c3+Sheet3!c3)...all the way to Sheet 37 This is very manual. I need to perform this same function for 106 cells. Is there a way to set up a range of the same cell from multiple worksheets?? I tried "sheet2!c3:sheet37!c3" to add all c3 cells from sheets 2-37 back to sheet 1. Didn't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
a unique cell value returns multiple cell values from another shee | Excel Worksheet Functions | |||
Continuall Add ing values in a cell | Excel Discussion (Misc queries) | |||
set hypothetical values for a cell | Excel Worksheet Functions |