Forum Discussion

Claire Buchtmann's avatar
Claire Buchtmann
Copper Contributor
May 16, 2018
Solved

Need help with an Excel roster document where I'm trying to journal hours

Hi - I'm trying to write a formula to add the number of hours across a month that somebody might work in a roster.  In that month they might work in 3 different areas, so I need to have the formula a...
Formulas & Functions
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    May 17, 2018

    Claire-

     

    Please try this formula.  The data is a little different then the initial file you provided which alters the formula a tad bit.  THe important thing is that the Employee # matches in both sheets in the exact same format / cells. :

     

     

     

    =SUMPRODUCT(('[Semester 2 Formula Help.xlsx]Class Support - South Region'!$B$6:$B$21=LOOKUP("Z",A$4:A4))*('[Semester 2 Formula Help.xlsx]Class Support - South Region'!$E$5:$FA$20=B3),'[Semester 2 Formula Help.xlsx]Class Support - South Region'!$E$6:$FA$21)

     

    Hope this helps!

     

John Jairo Vergara Domínguez's avatar
John Jairo Vergara Domínguez
Brass Contributor
May 16, 2018
Using the attachment provided by Matt Mickle, you can use the following formula in F8:

=SUMIF(D8:D15,"TRN",D9:D16)

Blessings!

Resources