SUMIFS Question

[kparadise]

Hello,

I have a table that contains 5 different groups of items. Each of those items have a price, on a separate reference table. I am trying to determine the total price of each group using a formula.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]ITEM 1
[/TD]
[TD]ITEM 2
[/TD]
[TD]ITEM 3
[/TD]
[TD]ITEM 4
[/TD]
[TD]TOTAL PRICE
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]apple
[/TD]
[TD]apple
[/TD]
[TD]orange
[/TD]
[TD]banana
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]orange
[/TD]
[TD]apple
[/TD]
[TD]orange
[/TD]
[TD]banana
[/TD]
[TD]18
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]orange
[/TD]
[TD]apple
[/TD]
[TD]orange
[/TD]
[TD]grape
[/TD]
[TD]17
[/TD]
[/TR]
</tbody>[/TABLE]

Reference table (this is on the same sheet. please follow the row and column headings)

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]O
[/TD]
[TD="align: center"]P
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD]Item
[/TD]
[TD]Price
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD]apple
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD="align: center"]10
[/TD]
[TD]orange
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD]banana
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD="align: center"]12
[/TD]
[TD]grape
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

I would like to put a formula in E2, and drag it down.

 

[kparadise]

SUMPRODUCT works great! Thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback