I have a sheet with a quantity in column a and a price in column b.

i want the sum of quantities at each price. The image is just a small piece. the list can get quite long. So at price 5665,5 the desired result would be 0 (-7 7 6-6 35-35)

CodePudding user response：

If you are on Microsoft-365 then could use

D2 cell =UNIQUE(B2:B18)
E2 cell =SUMIFS(A2:A18,B2:B18,D2#)

CodePudding user response：

I think you're talking about Pivot Tables. Just follow Microsoft official tutorial it's easy to use