Hi All,
I have attached a large sheet- the tab that I am working on is "Schedule Confirmation". In cell A2, I paste a Job# and cell B2 returns a line showing that this job is in my schedule. I am hoping to also total the Scheduled Press Time data in cell C2 but am having issues because some jobs have more than 1 part and require a total, not just the first part returned as a value (example Job# 246199 has 5 total parts for 1.68 hours but will only show .59 hours). The pasted the formula below.
=INDEX('ALL JOBS'!A5:D1000,MATCH(A2,'ALL JOBS'!D5:D1000,0),2)
Any help would be greatly appreciated!
Adam
Bookmarks