if multiple conditions are met, perform sum function using index function

[billrogers184]

I am using 2 separate work books (but I'll simulate using 2 worksheets within the same workbook) in which I am trying to list a result in a worksheet in one workbook if multiple conditions are met in another worksheet within a 2nd workbook. In my attachment, I am wanting the result to be listed on the "result tab" in E15(I have what the result should be in E15 on that tab).

The formula would be: sum (the corresponding value in the column named time*D9/ the corresponding value in column named %) if the text "Blue1" is in the color column and the text "Pear" is in the fruit column and the text "C" is in the lane column)...in this example if the conditions are met it would sum(G14*D9/H14)...if the text "Blue1" is in the color column and the text "Pear" is in the fruit column and the text "C" is in the lane column) the result would = sum(G15*D9/H15).

I've tried using a SUM(SUMIF formula but need to incorporate a INDEX function also (I think)...not sure how to make it work.

Thanks for any advice.

[jason.b75]

Based on your sample sheet,

=SUMIFS($G$8:$G$17,$J$8:$J$17,"Blue1",$F$8:$F$17,"C",$I$8:$I$17,"Pear")*$D$9/SUMIFS($H$8:$H$17,$J$8:$J$17,"Blue1",$F$8:$F$17,"C",$I$8:$I$17,"Pear")

This should be enough to get you started.

[billrogers184]

Thanks, that worked.