How do I count how many times each text appears in a column? For example I have this column:

```
foo1
foo1
foo1
too2
foo1
too2
mmm
mmm
foo1
```

Now I like to excute a function that shows me this result:

```
foo1 = 4
mmm= 2
too2 =2
```

Can this be done in a single advanced function?

i did try with COUNTIF but then i need to do on each text instance.

```
=COUNTIF(A1:A22601,"foo1")
```

but then i need to know which text's i have in each column. what i want is function that will take the column and calculate each text how many instances it has in the column

`countif`

statement – nixda Jan 23 '13 at 11:06`foo1 4`

,`foo1 4`

,`mmm 2`

,`mmm 2`

,`mmm 2`

,`too2 2`

etc? – Andi Mohr Jan 23 '13 at 11:28