I have two columns. Column A has names and Column B has dollar amounts.
I am looking to find the combined sum of each value in Column A and display the top 5 results.
I have tried multiple query formulas to no avail. I have looked through Stack Overflow but have not found an example that matches my problem.
Screenshot example is included below.
>Solution :
you can also try:
SORTN(BYROW(UNIQUE(A:A),LAMBDA(z,{z,SUMIF(A:A,z,B:B)})),5,,2,0)
](https://i.stack.imgur.com/PLHX0.png)](https://i0.wp.com/i.stack.imgur.com/WbDuK.png?w=1200&ssl=1)