number of cell

  • Thread starter Thread starter M.K
  • Start date Start date
M

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
 
no of cells: =COUNTIF(A:A,"a")
sum: =SUMIF(A:A,"a",B:B)

Regards,
Stefi

„M.K†ezt írta:
 
Back
Top