Home

Having a problem figuring out correct formula

%3CLINGO-SUB%20id%3D%22lingo-sub-638640%22%20slang%3D%22en-US%22%3EHaving%20a%20problem%20figuring%20out%20correct%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-638640%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20template%20that%20tracks%20labor%20for%20contract%20workers.%26nbsp%3B%20It%20tracks%20daily%20hours%2C%20and%20totals%20regular%20hours%20and%20OT%20hours%20for%20each%20week%2C%20and%20also%20totals%20the%20costs%20each%20week%20(hours%20*%20reg%20rate%2C%20hours%20*OT%20rate).%26nbsp%3B%20And%20each%20week%2C%20the%20hours%20are%20charges%20to%20a%20project%20ID.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20total%20costs%2C%20and%20project%20ID%20are%20on%20the%20same%20line%2C%20and%20there%20might%20be%20multiple%20contractors%20charging%20their%20time%20to%20the%20same%20Project%20ID.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20over%2070%20contractors%20that%20I'm%20tracking%20labor%20for.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20formula%20that%20will%20pull%20in%20the%20total%20costs%20for%20the%20week%20ending%20worked%2C%20based%20on%20the%20Project%20ID.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20-%20Jane%20Doe%20(Column%20A%20-%20Reg%20Hours%2C%20Column%20B%20-%20OT%20Hours%2C%20Column%20C%20-%20Project%20ID)%2C%20John%20Doe%20(Column%20D%20-%20Reg%20Hours%2C%20Column%20E%20-%20OT%20Hours%2C%20Column%20F%20-%20Project%20ID)%2C%20Sally%20Lu%20(Column%20G%20-%20Reg%20Hours%2C%20Column%20H%20-%20OT%20Hours%2C%20Column%20I%20-%20Project%20ID).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJane%20Doe%20and%20Sally%20Lu%20are%20charging%20to%20the%20same%20Project%20ID%2C%20but%20John%20Doe%20is%20not.%26nbsp%3B%20I%20need%20the%20formula%20to%20sum%20based%20on%20week%20ending%2C%20and%20Project%20ID.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3F%26nbsp%3B%20I%20haven't%20been%20this%20stuck%20on%20a%20formula%20in%20quite%20a%20while%20now.%26nbsp%3B%20I%20would%20appreciate%20any%20help!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-638640%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-642864%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20a%20problem%20figuring%20out%20correct%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642864%22%20slang%3D%22en-US%22%3EPlease%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E
Highlighted
SGrohola
Occasional Visitor

I am working on a template that tracks labor for contract workers.  It tracks daily hours, and totals regular hours and OT hours for each week, and also totals the costs each week (hours * reg rate, hours *OT rate).  And each week, the hours are charges to a project ID.  

 

The total costs, and project ID are on the same line, and there might be multiple contractors charging their time to the same Project ID.  

 

I have over 70 contractors that I'm tracking labor for.  

 

I need a formula that will pull in the total costs for the week ending worked, based on the Project ID.  

 

example - Jane Doe (Column A - Reg Hours, Column B - OT Hours, Column C - Project ID), John Doe (Column D - Reg Hours, Column E - OT Hours, Column F - Project ID), Sally Lu (Column G - Reg Hours, Column H - OT Hours, Column I - Project ID).

 

Jane Doe and Sally Lu are charging to the same Project ID, but John Doe is not.  I need the formula to sum based on week ending, and Project ID.  

 

Can anyone help??  I haven't been this stuck on a formula in quite a while now.  I would appreciate any help!  

1 Reply
Please attach your sample file.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies