I want to count a number of rows for each value appearing in a column. Is there an easy way to do this in excel?

Let's say I have the following table:

```
A B C
1 Cat A
3 Cat A
3 Cat B
4 Dog A
5 Cat B
```

I want to get the following result:

```
B Row_Count
Cat 4
Dog 1
```

Also, it would be nice to be able to SUM

```
B SUM_Col_A
Cat 12
Dog 4
```

But I cannot specify strings "Cat" and "Dog" explicitly because my columns contain >1000 distinct values.