Quote:
Originally Posted by Spencer101
I think this is what you mean.
I've included a SUMPRODUCT formula that will work in any version of Excel and a SUMIFS one that will work in 2007 or later.
There's a cell for the start and end of cost code range to make things easy to adjust to the individual job.
Let me know if that's not what you meant at all.
S.
|
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
Similar Threads
Threaded Mode
