Sum values depending on prefefined criterias
 

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

=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