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?
what do you mean link? i'm pretty noobie to excel
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.