In the attached document (simplified example - my actual spreadsheet is over 1000 rows) I am looking for the total time if the job and the op are the same.
I want the answer to be next to the last op (cells highlighted in yellow). I have put the correct answer in column G.
Would I use a SUMIFS statement here? Let me if more details are needed.
Bookmarks