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)
