Forum Discussion
Solved
The sum os the weight of the same shipment.
Good morning all,
Please i need help. How can i make the sum of different values of the same reference number?
I have an excel line with information about each package. But I need to have the sum of the packages' weight per shipment (customer order).
Client order number | Ship to Country | Weight (KG) |
1234 | NL | 1.034 |
1234 | NL | 2 |
1235 | DE | 0.356 |
1236 | BE | 0.25 |
1237 | LU | 9 |
1235 | DE | 1.545 |
1238 | AT | 2.93 |
1236 | BE | 1.205 |
1236 | BE | 2.96 |
1239 | NL | 1 |
1210 | FI | 5 |
1237 | LU | 6 |
Thanks in advance for your help.
JGA74 Purpose of this complicated formula is to find sum of unique clients then show dynamically so that when new clients entered, formula can spill results automatically by a single cell formula.
By SUMIFS(C2:C13,A2:A13,UNIQUE(A2:A13)) we find sum of unique values. And this UNIQUE(A2:A13) will list unique values of client everyone knows. By CHOOSE() function we have aggregate those clients unique values and their sums. CHOOSE({1,2}... will dynamically select those two columns will return as output. I will suggest to search on web for details about these formulas.
- Harun24HR, Hello,
I would like to understand the formula
=CHOOSE({1,2},UNIQUE(A2:A13),SUMIFS(C2:C13,A2:A13,UNIQUE(A2:A13)))
Please, can you explain this formula to me?
My DATA(excel sheet) has almost 35.250 rows. I tried this formula, but the result that i got was the "Client order number" instead the total of KG.
HansVogelaar maybe you can also explain the formula to me?
Thanks in advance,
