Hi all

I am using excel to calculate some statistics:

I have the following list

1) 2)
a) e n
b) e y
c) e y
d) e y
e) f n
f) f n
g) g y

I want excel to "calculate" the following values

e 1 n
e 3 y
f 2 n
f 0 y
g 0 n
g 0 y

I hope anybody can help me.

Best Regards