ExcelBanter - number of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - number of cell (https://www.excelbanter.com/excel-discussion-misc-queries/224538-number-cell.html)

M.K[_2_]

number of cell

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

number of cell

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

Regards,
Stefi

€žM.K€ ezt Ã*rta:

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

All times are GMT +1. The time now is 10:38 PM.