Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to add the same cell from several workbooks
I have several workbooks which are identical, but have different file names.
I need to add the same cell from the same worksheet in these different workbooks into another worksheet to get a total for the entire workgroup. Each workbook has a worksheet titled "Total Score", which has 2 values (in c2 and c4) that I need to add into a separate workbook. Is there a formula I can use to do this, rather than opening each workbook and clicking on the cell while I am in the formula bar? |
#2
|
|||
|
|||
Solved the problem. I ended up needing more information than just the two
cells, so I linked each workbook into a new one and then just did a sum. "cursednomore" wrote: I have several workbooks which are identical, but have different file names. I need to add the same cell from the same worksheet in these different workbooks into another worksheet to get a total for the entire workgroup. Each workbook has a worksheet titled "Total Score", which has 2 values (in c2 and c4) that I need to add into a separate workbook. Is there a formula I can use to do this, rather than opening each workbook and clicking on the cell while I am in the formula bar? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |