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 06, 2022
Thanks Harun24HR.

But one more question, whats means {1,2} on the Dynamic array approach formula?
The Dynamic formula will be better for me, Because i receive new DATA every day.
JGA74's avatar
JGA74
Copper Contributor
Sep 11, 2022
Thank you!

Resources