0

I want to combine the totals of four sheets into one.

I am creating a spreadsheet to keep track of the hours spent each day working on different project (M-F).

enter image description here

I have five days of data. They all have the same layout.

At the end of the week, I want to add up each row's sum for m-f and put in a separate sheet called end of week total so I can see how many hours each week we spent on a project. I am basically creating a spreadsheet for each day of the week that shows how many hours my employees worked on each project. At the end of the week I want all of the hours to add up, but only for each a specific row. not the total number of hours.

enter image description here

I have no idea how to combine sheets.

  • You can refer to other sheets when building a formula. When you've begun entering the formula on Sheet 5 and are at the point where you'd enter the cell address(es) you're summing, just flip over to the worksheet and cells you're trying to sum and select the cells as you normally would. – music2myear Jan 10 '17 at 22:39
  • imgur.com/a/Oju3e – kbeck2806 Jan 10 '17 at 22:40
  • imgur.com/a/nqBsL – kbeck2806 Jan 10 '17 at 22:41
  • I have five days of data. They all have the same layout. – kbeck2806 Jan 10 '17 at 22:41
  • I want to add up each row's sum for m-f and put in a separate sheet called end of week total. – kbeck2806 Jan 10 '17 at 22:44
0

I found the answer on my own.

Here is the link if anyone else needs help

https://www.youtube.com/watch?v=IRtgIfIfAHE

0

The formula in sheet5 should look like this:

=SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)

Replacing A1 with the column and row of the totals in sheets 1 through 4.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.