Re: How do you add together two cells in two different Microsoft Excel tables?
Hi Emmak,
Thanks for posting in our forums.
This post is identical to another one I replied to last month. So I will paste my same response here.
Is your data in 8 different Worksheets of the same Workbook? If that is so I think you can create a formula in the 9th worksheet and place a formula in the cell that you want the sum of the X2 cell of worksheets 1-8 to sum those. Should be as simple as entering the cell typing =SUM( and then going to each X2 cell in each worksheet with your mouse and selecting that cell so it appears as part of the formula and in between each selection making sure you enter a comma to separate them.
The formula should end up like:
=SUM(Sheet1!X2+,Sheet2!X2,Sheet3!X2,Sheet4!X2,Sheet5!X2,Sheet6!X2,Sheet7!X2,Sheet8!X2)
assuming each of your worksheets has the default name, otherwise instead of Sheet1, Sheet2, etc you should see there the names of your worksheets.
Cheers
====================================
Javier Treviño
MySQL on Windows Team
Subject
Views
Written By
Posted
1932
December 13, 2012 05:05AM
Re: How do you add together two cells in two different Microsoft Excel tables?
1165
January 15, 2013 05:37PM
893
February 27, 2013 05:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.