=sumproduct(--(A1:A100="e"),--(B1:B100="n"))
etc
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jakees" wrote in message
om...
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
|