I am trying to construct an array which will count text entries based
on text criteria for two other variables.I have tweaked this array
every way I can think of but keep getting #Value! Or 0.

This is basically what I have been working with:
{=SUM((Sheet1!$C$2:$C$500, A5)*(Sheet1!$D$2:$D$500,
B5")*Sheet1!E$2:E$500="YES")}

Sheet1: This is my data sheet. Column C is a list of names, Column D
is a list of month names and E is a list of YES or NO answers.

Sheet2: This is my tally sheet. Reference names are defined in column
A, reference months in column B. Column C is where my count formulas
are. I am trying to get the count of either the YES or NO answers.

Any suggestions?
Tim