counting from columns using criterias

Hi



I have a list of data that I what to count depending on what the criteria is.

eg.

Retire Name Outcome
Y Bob E
Y Bill C
N Joe C
N James C
N Julie C
N Travis I
N Bobby I
N Tom I


On the summary page I want to have the following

Outcome E where Person was retired = should be 1
Outcome C where person was not retired = should be 3
Outcome I where person was retired = should be 0

how would I create a formula for this. I was thinking of dcounta but not sure how to make a multi critria forumla.

Try SUMPRODUCT, e.g. for your first count

=SUMPRODUCT(--(A2:A9="Y"),--(C2:C9="E"))