Merging data

**hello its dean** · 01-24-2013, 08:54 PM

I have a spreadsheet I use at work with a different worksheet for each day displaying what the staff have achieved and a sheet for a weekly total, bearing in mind that the staff can vary from day to day.
How can I merge the data from all the other sheets in to the weekly total sheet to show the total productivity for that week?

Here is a simple example of what I am trying to achieve..

help.jpg

And here is the file..

help.xls

Cheers guys!

(Apologies for posting this already in someone else's thread)

**FDibbins** · 01-24-2013, 09:13 PM

Thanks for starting a new thread Dean

before I even try to answer this 1, is it really necessary to have (potentially) 365 different worksheets?

I would suggest that you re-think the layout of your data so that you can enter all data into 1 worksheet, and then have a 2nd sheet with your summary on it.

If you ask any of the experts here, they will agree that in almost every case, it is better to have 1 sheet as a data entry sheet, and another sheet (or sheets) for summaries etc

**rcm** · 01-24-2013, 09:15 PM

the formula is sumif(). You need a sumif() for every day of the week.I included a checksum in B11 of Weekly Total to ensure everybody was accounted for.