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.
<tbody>
</tbody>
Reference table (this is on the same sheet. please follow the row and column headings)
<tbody>
</tbody>
I would like to put a formula in E2, and drag it down.
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.