Array of Partial Sums

[galileogali]

Excel Workbook
	A	B
1	c	4
2	d	3
3	ba	5
4	z	1
5	r	2
6	a	6
7		21
8
9
10	c	21
11	d
12	ba
13	z
14	r
15	a
Hoja1

My question: How to obtain an Array into my Formula 1 x 6 or 6 X1, with the Partial sums of each boolean-Row?

See:
SUMPRODUCT(N({TRUE;TRUE;FALSE;TRUE;TRUE;FALSE\ = 4
FALSE;TRUE;FALSE;TRUE;TRUE;FALSE\ = 3
TRUE;TRUE;TRUE;TRUE;TRUE;FALSE\ = 5
FALSE;FALSE;FALSE;TRUE;FALSE;FALSE\ = 1
FALSE;FALSE;FALSE;TRUE;TRUE;FALSE\ = 2
TRUE;TRUE;TRUE;TRUE;TRUE;TRUE\})) = 6


I want : {4\3\5\1\2\6}
and then I will can to apply LARGE or SMALL functions

 

[galileogali]

Is FREQUENCY my Key?

 

[barry houdini]

Perhaps try COUNTIF......

=COUNTIF(A1:A6,">="&A1:A6)

 

[galileogali]

Thanks, Barry
Exactly that I need

note that the result you got with your help

Excel Workbook
	A	B
10	c	z
11	d	r
12	ba	d
13	z	c
14	r	ba
15	a	a
Hoja1