so I'm trying to sum by ticker and rank largest to smallest (not sure how to do it with same ticker for different lots/amounts)

[speckledtrout]

I have data in two columns such as:

AA 50
AA 30
bb 19
XX 20
XX 10

I'm trying to sum by column A inputs and rank highest to lowest by the summed numbers using column B values

 

[admiral100]

Hi,

One way :-

Ctrl+Shift+Enter NOT just Enter

D2 =IFERROR(LARGE(--(FREQUENCY((SUMIF($A$2:$A$6,$A$2:$A$6,$B$2:$B$6)),(SUMIF($A$2:$A$6,$A$2:$A$6,$B$2:$B$6))) < 2)*SUMIF($A$2:$A$7,$A$2:$A$7,$B$2:$B$7),ROWS(D$1:D1)),"")

[TABLE="width: 359"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Text[/TD]
[TD]Numbers[/TD]
[TD][/TD]
[TD]Total Per Text[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AA[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]AA[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BB[/TD]
[TD]19[/TD]
[TD][/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]XX[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]XX[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]