SUMIF failure

Marvin Daniels

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)

Kimberly Loveless

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

Kimberly Loveless

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

Marvin Daniels

Kimberly: That was it! You are 100% correct that SUMIF seems backwards and I know I've made this mistake before, however, I couldn't see it for the life of me this morning. Thanks so much! 😀

Kimberly Loveless

@Marvin Daniels you are welcome 😁

I completely understand I only recently got it in my head that SUMIF is different.