There are 2 columns. 1st one with values in TEXT format - SKU, 2nd one with integer values. How to create expression to sum qty from the second column according to the conditions of matching the specific SKU from the first? For ex Im interesting in sum of the values that match SKU/3 which should be 26? Should I use SUM or COUNT expression. What conditions should I used?
Thanks
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |