Forum Discussion
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.
9 Replies
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,
