I'm trying to summarize the expanded table in the summary table. To this end, I'm trying to come up with a formula in column F under "Goods" to return the first matching cell's value (text) in column B whenever column A equals column E.
I've also added an outcome table to show what I expect.
Any solution?
قبض انبار.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Expanded Table | Summary Table | |||||||
2 | |||||||||
3 | |||||||||
4 | Code | Goods | value | Code | Goods | value | |||
5 | 1 | backpack | 10 | 1 | 19 | ||||
6 | 1 | pen | 1 | 2 | 8 | ||||
7 | 1 | pencil | 1 | 3 | 18 | ||||
8 | 1 | eraser | 2 | 4 | 9 | ||||
9 | 1 | notebook | 5 | ||||||
10 | 2 | apple | 1 | ||||||
11 | 2 | orange | 1 | ||||||
12 | 2 | banana | 2 | ||||||
13 | 2 | pineapple | 3 | Outcome | |||||
14 | 2 | carrot | 1 | ||||||
15 | 3 | shirt | 6 | ||||||
16 | 3 | t-shirt | 5 | ||||||
17 | 3 | pants | 4 | Code | Goods | value | |||
18 | 3 | hat | 3 | 1 | bcakpack | 19 | |||
19 | 4 | water | 1 | 2 | apple | 8 | |||
20 | 4 | lemon juice | 2 | 3 | shirt | 18 | |||
21 | 4 | tea | 3 | 4 | water | 9 | |||
22 | 4 | coffee | 3 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G5:G8 | G5 | =SUMIF($A$5:$A$22, E5, $C$5:$C$22) |
I've also added an outcome table to show what I expect.
Any solution?