+ Reply to Thread
Results 1 to 3 of 3

Total Hours worked per Job or Worker

  1. #1
    Registered User
    Join Date
    07-19-2012
    Location
    Chicago
    MS-Off Ver
    2007
    Posts
    2

    Total Hours worked per Job or Worker

    I'm trying to improve the log that I use to track my workers whereabouts so I can improve job costing. I've been manually adding up different jobs from the attached sheet but want to make it do this automatically. I've got a column with hours worked on a job, then a column with the specific number on for that job, and then a column with the job's name. I want to find out how to make something at the bottom of the sheet that will take column E and add up all values in column F that correspond with that certain value in E. Please see attached sheet, I can write better instruction on there. Thank you.
    Attached Files Attached Files
    Last edited by arlu1201; 07-19-2012 at 02:17 PM.

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need help with a formula

    Use

    =SUMIF($E$6:$E$56,1,$D$6:$D$56)

    Replace the highlighted in blue to 2 or 3 to get results for the others
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,033

    Re: Need help with a formula

    Hi DJohnson2 and welcome to the formum,

    Could you edit your original post and change the title to something like "Total Hours worked per Job or Worker" so we can find it later. Your title is too generic (common).

    See the attached for how I'd be doing this problem. Hope this helps. Did you change the thread title yet?
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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