Quote:
Originally Posted by Opie82
Thanks S. I think that would work if I just had one job, or I knew where each job was located. But I have downloaded data that is a list of costs for 50+ jobs. So I think I need a VLOOKUP function to make sure the job # matches first.
I've attached a partial example of the database and the summary where I want to pull the results to. There are 5 different sample jobs shown on the data page (out of 50+). Only the green highlighted lines meet the criteria.
I want the answers to come to the summary tab going across columns. Unfortunately I'm working with the 2003 version.
Thanks, Andy
|
You can accomplish that by adding another condition to the SUMPRODUCT.
Have a look at the attached now.
I changed the formatting on Column E of the "JC data" worksheet so the values are numbers and added the extra condition to the formula I provided before.
Is that of any use to you?
Worth noting that you have two jobs with the number 1003 so that value gets duplicated in the first and last job column.