SUM of repeating values

[AndrewS6]

A 10
B 12
C 15
D 16
E 5
A 7
B 9
C 5
A 11
B 12
A 10




Count Sum
1 2
2 1
3 1
4 1

The count column is counting the number of times a certain item appears in a column (ie there are 2 items that appear once D & E, 1 item that appears twice C, etc). The formula i am using in the Count column is =(SUMPRODUCT((COUNTIF($A$1:$A$14,$A$1:$A$14)=$A17)+0))/ (1,2,3 or 4)

I want a forumla to count the sum of the items that appear once, twice, three times etc. It should give the results as below


Count Sum
1 2 21
2 1 20
3 1 33
4 1 38


Thanks
Andrew

[JBeaucaire]

In C17 and copied down:

=SUMPRODUCT((COUNTIF($A$1:$A$14,$A$1:$A$14)=$A17)+0, $B$1:$B$14)