Forum Discussion

Copper Contributor

Aug 29, 2022

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 s...

excel

Harun24HR
Aug 29, 2022
JGA74 Try below dynamic array formula to spill results automatically. Download the attached file.
=CHOOSE({1,2},UNIQUE(A2:A13),SUMIFS(C2:C13,A2:A13,UNIQUE(A2:A13)))
If you do not have Microsoft365 then try below formula.
=SUMIFS($C$2:$C$13,$A$2:$A$13,H2)

Harun24HR

Bronze Contributor

Aug 29, 2022

JGA74 Try below dynamic array formula to spill results automatically. Download the attached file.

=CHOOSE({1,2},UNIQUE(A2:A13),SUMIFS(C2:C13,A2:A13,UNIQUE(A2:A13)))

If you do not have Microsoft365 then try below formula.

=SUMIFS($C$2:$C$13,$A$2:$A$13,H2)

JGA74
Copper Contributor
Sep 05, 2022
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,
- HansVogelaar
  MVP
  Sep 05, 2022
  JGA74
  
  I'll leave it to Harun24HR to explain that formula. To be honest, it seems overkill to me - the SUMIFS formula is shorter, easier and works in all recent versions of Excel.
JGA74
Copper Contributor
Aug 29, 2022
THANKS A LOT Harun24HR!!!!!
I used the SUMIFS and it worked!!! Thank you Thank You Thank you!!