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)

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 06, 2022

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.

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!
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Sep 06, 2022
    {1,2} this mean column 1 and column 2.
    • JGA74's avatar
      JGA74
      Copper Contributor
      Sep 11, 2022
      Thanks a lot Harun24HR

Resources