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. |
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 |