SUMIF failure


I'm trying to improve a labor intensive process (40+ spreadsheets that do not interact) to calculate a a weekly production metric by Examiner. Basic workflow is that Examiners enter time worked in various categories daily, then once a week production numbers are added and the metric will be calculated. I created the sheet with a form for the Examiners to add hours and that works fine, however, I am stuck on what seems like a simple formula. Please see the screen capture for a better visual.

=SUMIF([process time]:[process time], weeknumber:weeknumber = weeknumber@row)

Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    I think that this should work ....

    =SUMIF(weeknumber:weeknumber, = weeknumber@row,[process time]:[process time])

    Sumif is a little backwards to me as the range to sum is actually at the end.

    Let me know if this works


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!