hi all

if i have the following:

a 12
b 10
c 15
a 11
a 7
a 14
c 1
c 21


how i can collect the following
no of cell which hvae a and total of it

for example the result will be as following

the number of a cell will be 4 and in other cell get the amount of a only
12+11+7+14