Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-3121195%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3121195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20seeking%20help%20with%20a%20formula.%20I%20have%20staff%20using%20same%20excel%20worksheet%20for%203%20shifts.%20I%20need%20the%20stats%20from%20each%20individual%20worksheet%20for%20specific%20day%20and%20shift%20to%20populate%20on%20a%20monthly%20report%20for%20each%20shift.%20Currently%20have%20someone%20that%20manually%20enters%20the%20data%20into%20each%20shift%20on%20the%20monthly%20report.%20The%20worksheets%20have%20staff%20member's%20name%20and%20shift%20on%20one%20sheet%20of%20worksheet%20and%20the%20other%20sheets%20have%20totals%20for%20specific%20work%20performed%20and%20another%20sheet%20that%20they%20fill%20in%20all%20necessary%20information%20that%20provides%20totals%20for%20each%20task%20done%20on%202%20sheet.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20assistance%20would%20be%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3121195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3121286%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3121286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1298102%22%20target%3D%22_blank%22%3E%40dave_2250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EI%20recommend%3A%20Always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20not%20to%20be%20misunderstood%2C%20the%20aim%20of%20Excel%20users%20is%20to%20provide%20assistance%20on%20projects%20(to%20other%20Excel%20users)%2C%20or%20to%20give%20food%20for%20thought%20and%20not%20to%20deliver%20finished%20work%20or%20finished%20ideas.%20If%20someone%20wants%20to%20have%20a%20finished%20project%2C%20it%20should%20be%20commissioned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am seeking help with a formula. I have staff using same excel worksheet for 3 shifts. I need the stats from each individual worksheet for specific day and shift to populate on a monthly report for each shift. Currently have someone that manually enters the data into each shift on the monthly report. The worksheets have staff member's name and shift on one sheet of worksheet and the other sheets have totals for specific work performed and another sheet that they fill in all necessary information that provides totals for each task done on 2 sheet.

Any assistance would be appreciated.

2 Replies

@dave_2250 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

In order not to be misunderstood, the aim of Excel users is to provide assistance on projects (to other Excel users), or to give food for thought and not to deliver finished work or finished ideas. If someone wants to have a finished project, it should be commissioned.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Thank you for the input.  We use Excel version 2013 and Windows operating system. sample worksheet.JPGSample worksheet page 2.JPG We save our information to Sharepoint.  I have attached sample worksheet to show where data needs to be pulled from and the 2nd sheet where information is entered.

I forgot to mention the formula needs to pull data from worksheets based on Date and Shift.  This information needs to be transferred to a monthly report.

 

I hope I have made it easier to understand what I am asking assistance on.  I appreciate any further input.