Sum Two Different Sheets Together In Excel

i am doing pay for work and dealing with 2 different sheets with 10 peoples hours on them. 1 sheet is 1 weeks hours therefore 2 weeks all up.
is there a quick way that i can sum up each persons total hours while keeping the same layout as the 2 normal sheets?
thanks
what do you mean link? i'm pretty noobie to excel
Posted: June 14, 2013

Best Answer

Hi, You have to link the two sheets in the third sheets. I imagine that you are having week as the basis for your sheets. Just add one more sheets, or if you want the result on the 2nd sheets, then link the two sheets , by placing this equal =sign where you want the total, and then go to the sheet where the hours of work has been already totalled and click. You will find (=sheet1 and the concerned cell you clicked ) in the cell you have given the =sign. Equal sign in excel means , calculation. It gives the excel that it is a formula it has to calculate. Thus you give link to all the persons. This you can do by filling the same formula, by copying the formula, and pasting in al the cells down the line in the column.When you place your cursor, to the first link you created, if you hover around the right bottom, you will see a small +sign. you drag this plus down the line, so the formula is getting copied to the cells your desired. Thus you could get the total of each of the workers.

Related Questions

1+
answers
Do I Get Excel Sheets Of Supermarket What They Used For Billing In Olden Days?
Actually I want the microsoft excel sheets(if not any other spread sheets) of supermarket or any other grocery store. which are used for billing and maintaining...
May 29, 2013
1+
answers
Help Me Solving An Excel Vba Problem Please
I need to do a smoothing calculation in Excel. In VBA I wrote this procedure Sub Smoothing() For i = 1 To 100 For j = 2 To 100 For k = 2 To 100 Sheets("y...
May 10, 2013
2+
answers
How Can I Create A Word Sheet In Excel Instead Of A Spreadsheet?
I want to have a excel document where i can type in notes on one of the sheets in my excel file. I like to have one file for a number of things with multiple sh...
June 14, 2013
1+
answers
Help With Excel Macros?
im making a macro in my spread sheet so that if someone was to enter a 0 or leave the cell blank that it would come up with a error message but it keeps coming ...
May 19, 2013
5+
answers
How Can I Move Excel Data From One Worksheet To Another...?
Hello, I have two different excel sheets containing a list of companies and other information about these companies.. Sheet A and Sheet B both have different...
May 29, 2013
1+
answers
Excel Keyboard Shortcuts / Macros?
Guys, Need a little help. I have a user who enters time sheets in an excel spreadsheet. The user wants to be able to press full stop twice and excel should ...
June 14, 2013
2+
answers
You Make A Search Box On Excel
I have a database on excel it consists of two axis, the vertical axis is peoples names, I want to create a search box in which you type a name in the their row ...
June 14, 2013
1+
answers
How Do You "freeze" (keep From Changing) Sheets In Excel?
Doing some amateur accounting in excel, and I have one "master" sheet with every transaction on it. The weekly income statements and balance sheets are made usi...
June 14, 2013
2+
answers
Excel Help With Imputing Values?
How do i pull a value from a cell in excel and have it input in another cell in another sheet in the same document. So to be more exact i have 3 sheets on my e...
May 20, 2013
1+
answers
Which Sites Is The Best For Free Excel Spread Sheets And Excel Database Templet
I Need Top Reating Excel Free Database and spread Sheet. Templet sites Address. Where in find ...
May 10, 2013
3+
answers
How Can I Have Two Excel Files Open At The Same Time In Separate Windows (2007)?
I need to have two excel sheets open at the same time. When I click on one file on the task bar, it hides the other one and I have to go back and forth on the t...
May 19, 2013
1+
answers
Export Data In Csv/excel File Using Vb 6
i try to used visual basic 6 and make a software that can be use by a client in scanning a barcode then it reveals the content data in the textbox and listview ...
May 10, 2013
1+
answers
Best Site To Practice Excel
best site to practice Excel? I have to take an Excel test for job placement and I’d like to brush up on my Excel skills. I use to be good at it but si...
May 19, 2013
4+
answers
What Type Of Bed Sheets Would Normal Guys Have
Look I'm 13 close to 14 and I want to clean up my room and have like new sheets and everything, I don't know what I should get, I want to get like red bed sheet...
May 10, 2013
1+
answers
Versions Excel Documents In Windows Xp?
I have ve lost a big amount of data in one of my excel documents, as a matter of fact i have had 6 sheets, one sheet with at least 3800 rows an 6 columns. I ope...
May 29, 2013

Page Loaded:0.03