number of cell

[M.K]

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

 

[Stefi]

no of cells: =COUNTIF(A:A,"a")
sum: =SUMIF(A:A,"a",B:B)

Regards,
Stefi

„M.K†ezt írta: