I’ve got two lists: one with items and one with orders
| Item | Price |
|---|---|
| 1 | 10.10 |
| 2 | 2.02 |
| Order | Item 1 | Item 2 | … | Item 15 |
|---|---|---|---|---|
| A | 1 | |||
| B | 1 | 3 |
For each order I want to sum up the prices of the items listed in that row.
I’ve tried searching for a formula but everything I’ve found refers to a different problem. Either they want to sum up multiple columns of a single result or they want to look up multiple rows based on a single value. And I’ve not been able to adapt those formulas or ideas to my problem.
Use MAP() then SUM(). Try-
=SUM(MAP(E2:H3,LAMBDA(x,XLOOKUP(x,A2:A,B2:B,0))))
2