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
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
Highlighted
Please attach your sample file.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies