Hi all,

I have a counting issue. Let's assume the follwing data set:

¦ A ¦ B ¦
---------------------------
1¦ a ¦ 2 ¦
2¦ b ¦ 1 ¦
3¦ a ¦ 5 ¦
4¦ c ¦ 2 ¦
5¦ b ¦ 2 ¦


Result:
a 7
b 3
c 2

How can I get this done with a formula? I have tried with countif but it did
not work.

Kind regards,

Simon