Spreadsheet: 786800d1657455265-sum-values-with-multiple-columns-2022-07-10-oeldere-miazra-book1-5-
Sheet: Sheet1

 |  |  |  | TABLE 1 |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
 |  |  | Name | PO1 | PO12 | PO2 | PO3 | PO4 | PO43 | PO5 | PO6 | PO7 | PO8 |  |  | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 |  |  |  |  |  |  | Som van Value | Kolomlabels
 |  |  | Name A | 7 | 12 | 2 | 0 | 1 | 2 | 0 | 5 | 3 | 0 |  | Name A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rijlabels | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 | Eindtotaal
 |  |  | Name B | 12 | 19 | 4 | 4 | 4 | 2 | 1 | 4 | 3 | 7 |  | Name B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name A | 19 | 2 | 0 | 3 | 0 | 5 | 3 | 0 | 32
 |  |  | Name C | 11 | 22 | 4 | 3 | 3 | 4 | 0 | 3 | 0 | 2 |  | Name C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name B | 31 | 4 | 4 | 6 | 1 | 4 | 3 | 7 | 60
 |  |  | Name D | 7 | 21 | 0 | 5 | 3 | 1 | 1 | 4 | 1 | 6 |  | Name D |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name C | 33 | 4 | 3 | 7 | 0 | 3 | 0 | 2 | 52
 |  |  | Name E | 0 | 3 | 6 | 7 | 2 | 2 | 2 | 1 | 4 | 5 |  | Name E |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name D | 28 | 0 | 5 | 4 | 1 | 4 | 1 | 6 | 49
 |  |  | Name F | 13 | 4 | 0 | 7 | 3 | 0 | 3 | 1 | 2 | 7 |  | Name F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name E | 3 | 6 | 7 | 4 | 2 | 1 | 4 | 5 | 32
 |  |  | Name G | 3 | 3 | 2 | 0 | 4 | 2 | 1 | 1 | 2 | 1 |  | Name G |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name F | 17 | 0 | 7 | 3 | 3 | 1 | 2 | 7 | 40
 |  |  | Name H | 9 | 28 | 6 | 2 | 2 | 0 | 2 | 3 | 2 | 3 |  | Name H |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name G | 6 | 2 | 0 | 6 | 1 | 1 | 2 | 1 | 19
 |  |  | Name I | 11 | 30 | 9 | 5 | 2 | 5 | 3 | 5 | 3 | 6 |  | Name I |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name H | 37 | 6 | 2 | 2 | 2 | 3 | 2 | 3 | 57
 |  |  | Name J | 11 | 12 | 10 | 4 | 1 | 2 | 1 | 1 | 2 | 10 |  | Name J |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name I | 41 | 9 | 5 | 7 | 3 | 5 | 3 | 6 | 79
 |  |  | Name K | 2 | 12 | 0 | 3 | 1 | 3 | 3 | 2 | 5 | 9 |  | Name K |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name J | 23 | 10 | 4 | 3 | 1 | 1 | 2 | 10 | 54
 |  |  | Name L | 4 | 3 | 9 | 0 | 0 | 4 | 1 | 1 | 4 | 6 |  | Name L |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name K | 14 | 0 | 3 | 4 | 3 | 2 | 5 | 9 | 40
 |  |  | Name M | 0 | 3 | 2 | 0 | 2 | 5 | 0 | 5 | 3 | 8 |  | Name M |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name L | 7 | 9 | 0 | 4 | 1 | 1 | 4 | 6 | 32
 |  |  | Name N | 2 | 3 | 6 | 3 | 4 | 4 | 0 | 5 | 0 | 2 |  | Name N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name M | 3 | 2 | 0 | 7 | 0 | 5 | 3 | 8 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name N | 5 | 6 | 3 | 8 | 0 | 5 | 0 | 2 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. I have a data namely Table 1. In the Table 1 consists of Names (A-N) & POs (1 to 8). |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 267 | 60 | 43 | 68 | 18 | 41 | 34 | 72 | 603
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. My problem is I want to sum the values according to each PO as you can see in the Table 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. I tried to use filter and sum functions. However, it adds up all the values in column PO1.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Example: Other POs are no issue, and the problem is Name A supposedly get values of 19 (7+12) for PO1 and 3 (1+2) for [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. I hope anyone experts here can help me to solve this problem. I appreciate any help you can provide. Thank you!