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)),"")

	A	B	C	D
1	Text	Numbers		Total Per Text
2	AA	50		80
3	AA	30		30
4	BB	19		19
5	XX	20		0
6	XX	10		0

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>