I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number was used in a job. I am trying to add a column to sum the costs of the part number. I've done an Index/Match to find the part number used in the job from the spreadsheet that has the cost information. My problem is I am only getting the first cost in the array, I need a sum of all the costs. Can some one please help me figure out what I'm doing wrong? Thank you in advance.
Below Part Number is Column B and Total Cost is S: **Part Number** **Total Savings** 880105-204-DN $(0.53) 2187 $- 4558 $- 020-9057 $(4.05) TF-100-1017 $- 472-4391 $17.21 TF-1800-2029 $- W5-5170-1 $0.29 W5-5170-2 $0.29 10411 $- 4558 $- 880105-583-ft $3.38 472-4391 $0.42 TH-300-0146 $-
Below is where I am trying to do the formula:
**Item** **Feb Savings** 880105-204-DN $(0.53) 020-9057 $(4.05) 472-4391 $17.21
Here is my formula: =INDEX('FromDB-15'!S:S,(MATCH([@Item], 'FromDB-15'!B:B, 0)))