Say I have an Excel worksheet with two columns and five rows like this:

Type Value ---------- B 1 A 4 B 2 B 2 A 4

How can I get Excel to aggregate the data for me? I want something like this (SUM):

Type Sum -------- A 8 B 5

or like this (COUNT):

Type Count ---------- A 2 B 3

Of course, this is just sample data. The real sheet has a few hundred types, each with dozens to hundreds of entries. I don't want to use a macro. I have access to Excel 2010 and Excel 2013.