INDEX/MATCH help

[Yamezz]

I would like to have a formula that gives the sales rate of the current product on the market, from the following table

Product	Batch	Current	Rate
Apple	14	X	24
Apple	16		28
Apple	17		2
Orange	22	X	119
Banana	17	X	188
Banana	19		0
Result:
Product	Rate
Apple	24
Orange	119
Banana	188

The Results, which I've manually entered to show what I'd expect from the formula, would find the Rate where the Product is Apple and the Current column has an "X" (indicating that this is the batch of that product that is currently being sold). I presume INDEX/MATCH is the way to go, but I've got myself muddled. Any help would be appreciated.

 

[zepharoz]

I think sumifs is your answer, assuming you only have one current Apple at any given time.

=sumifs(columnD range, columnC range, "X", ColumnA range, $A11)

Where A11 is the criteria you are looking for.

Index match can work. But can be confusing.
=INDEX($D$2:$D$6,AND(MATCH($A11,$A$2:$A$6,0),MATCH("x",$C$2:$C$6,0)))

 

[Yamezz]

Thanks *zepharoz, the SUMIFS formula did it.