This will likely be long winded, I apologize now. (some data removed and names changed for NDA reasons)
Basically I'm trying to sum these by the number in the middle, using the Plus/minus and Steak/Pastry/Apples. In the full dataset, the numbers in the middle repeat and are shared by pastry and steak. For example, A number can both be plus and minus while also being from Pastry, Steak, and Apple. The formula I had prior =SUMIF(A:B,A2,B:B), would add up the numbers correctly, but I still have the issue of having multiple sums for the same concate in use.
I tried to explain it the best I could. If I didn't make sense I'm so sorry, I will try to explain further if need be.
Basically I'm trying to sum these by the number in the middle, using the Plus/minus and Steak/Pastry/Apples. In the full dataset, the numbers in the middle repeat and are shared by pastry and steak. For example, A number can both be plus and minus while also being from Pastry, Steak, and Apple. The formula I had prior =SUMIF(A:B,A2,B:B), would add up the numbers correctly, but I still have the issue of having multiple sums for the same concate in use.
I tried to explain it the best I could. If I didn't make sense I'm so sorry, I will try to explain further if need be.
| Concate in use | Value to be Added | SUM |
| Pastry;1002757132;Plus | -4 | |
| Steak;1002757126;Plus | -12 | |
| Steak;526749;Plus | -10 | |
| Steak;201032;Minus | 2 | |
| Apples;207598;Plus | -6 | |
| Steak;224892;Minus | 2 | |
| Steak;155460;Minus | 4 | |
| Steak;155559;Plus | -4 | |
| Steak;713708;Plus | -2 |
