Forum Discussion

JGA74's avatar
JGA74
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's avatar
    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)

     

     

JGA74's avatar
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's avatar
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.

Resources