How do you add together two cells in two different Microsoft Excel tables?
Friday, December 25th, 2009 at
11:14 am
I have eight years of data in eight different Microsoft Excel tables in one spreadsheet. I want to add the cell X2 from each table together and place it on a ninth table. Is it possible to do this?
Related posts:
- How do I divide a row by another row in a data table in Microsoft excel? Yeah, I am entering in a data table. I just...
- How do I export an Excel Spreadsheet of e-mail addresses to Yahoo? I have converted the Excel spreadsheet to a CSV file,...
- How do I remove Duplicate rows with same first column, but different other columns in Microsoft Excel? I have date I am trying to consolidate in Microsoft...
- How do you work around this query problem on Microsoft Access? I need to do an assignment involving making a database...
- How can I insert bullets and numbering in Microsoft Excel? Hi, I have a problem that I want to insert...
Filed under: Microsoft
Like this post? Subscribe to my RSS feed and get loads more!
Do you mean "eight years of data in eight different Microsoft Excel worksheets in one workbook" as multiple tables on one spreadsheet would have different cell references.
If you do have multiple worksheets then the formula in cell X2 in the 9th worksheet would be
=SUM(Sheet1!X2 + Sheet2!X2 + Sheet3!X2+ Sheet4!X2+ Sheet5!X2+ Sheet6!X2+ Sheet7!X2+ Sheet8!X2 )
The reference to Sheet1 to Sheet8 would be changed to the names of the sheets in your workbook (if you have spaces in the name put the name in square brackets like [Sheet 1]