# Help with a formula/Function for totaling hours for a job

1. ## Help with a formula/Function for totaling hours for a job

Hello

I've been wracking my small brain on trying to figure this out for my wife. She has one workbook with 7 sheets. the rows of each sheet are the weeks of the year and every two columns is a job, the first of the two being hours the second being hrs times rate of pay. Now each sheet is the same as in the 8th column will all be the same job. I'm trying to figure out how to scan a specific job hours column in every sheet and display results of any row that is not null/zero. This display on another sheet. That way when her boss asks how much labour on job x, she could this formula to figure it out instead of going through each sheet and totalling numbers etc etc.

Any help would be greatly appreciated as my brain is not wrapping around what functions to use and in what order.

Joel

2. ## Re: Help with a formula/Function for totaling hours for a job

Hi
Please read the yellow banner at the top of the page explaining how to upload a sample file.

3. ## Re: Help with a formula/Function for totaling hours for a job

Oops, sorry

Here is an example

4. ## Re: Help with a formula/Function for totaling hours for a job

So seet "Empoyee 7" is your sum up results?
How did you get to 15.5 hours on pay period Dec 29-Jan 3?

5. ## Re: Help with a formula/Function for totaling hours for a job

Hello

No Employee 7 is a new employee who they haven't made a full sheet for yet. He can be deleted probably as his would mess things up lol

6. ## Re: Help with a formula/Function for totaling hours for a job

I introduced a summary worksheet: "main" a portion of which is shown below.

dmferd.png

The formula in cell main!B2 copied across and down is:
Formula:
`Please Login or Register  to view this content.`

Note that there are a few #N/A errors. These are due to "job" columns missing from certain employees, for example 19-1026 is missing from the Employee2 worksheet.

There's also a couple of #REF errors - for example you have #ref! errors in Employee4!AM30:AM60 that will lead to erroneous results

Either the data can be cleaned up or possibly I can adjust the formulas to tolerate these errors. I'll leave work on this until you confirm that this solution is along the lines you were looking for.

The above is implemented in the attached workbook.

Hope this helps

7. ## Re: Help with a formula/Function for totaling hours for a job

This looks awesome, thank you, I will check it out and fix things over the weekend and let you know

Joel

8. ## Re: Help with a formula/Function for totaling hours for a job

Don't work too hard over the holiday weekend
Thanks for the feedback and reputation points.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1