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.

	A	B	C	D	E
1	ITEM 1	ITEM 2	ITEM 3	ITEM 4	TOTAL PRICE
2	apple	apple	orange	banana	22
3	orange	apple	orange	banana	18
4	orange	apple	orange	grape	17

<tbody>
</tbody>

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

	O	P
8	Item	Price
9	apple	6
10	orange	5
11	banana	2
12	grape	1

<tbody>
</tbody>

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