We help IT Professionals succeed at work.

Excel totals by filter - Automated

59 Views
Last Modified: 2016-10-24
I need to create an Excel sheet that supervisors will be entering data into on a daily basis that will how many pieces were produced by process.  These supervisors do not have any Excel experience so I need to make things as simple as possible.  This data will be on going and some jobs may take several weeks before it is completed.  Once a job is completed I need to total the pieces produced by the process that was performed and the total hours that it took.  There are just (5) different types of processes and not all of them will be used on each job.  But at the end of the job I need to know that 'X' number of hours were spent performing 'Y' process.  During the course of a month there will be one hundred to two hundred different jobs.  When the job is complete the supervisors need to take this information and enter it into our ERP system.  Because of how the ERP system works, they will need all the totals at the same time.  They will be entering in the total hours used for each process into the ERP system.  

I thought about putting some sumif statements to sum up each one of the 5 process types and that would work; except I'd like to not  display this unless there is a filter on to filter only one job at a time.  Is there a way to achieve this?  Or is there a better way to handle what I'm trying to accomplish?
C--Users-staylor-Desktop-PRODUCTION.xlsx
Comment
Watch Question

Group Finance Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Sue TaylorProject Manager

Author

Commented:
I never thought of that!  Excellent idea.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Post back if you want more help.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Pleased to help
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.