count text function 3 criteria

[timh2ofall]

Trying to construct an array Count formula where column A defines
names, column B defines months, and column C defines yes or no.
A B C
Ted August Yes
Bill August No
Ted September Yes

I want to count the number of Yes or No and must use text. Tried this
to no avail: {=SUM((sheet1!$F$2:$F$500="TED")*(sheet1!$B$2:$B$500="September")*sheet1!AD$2:AD$500="yes")}
Appreciate any help.
Tim

 

[Jerry W. Lewis]

Did you array enter the formula (Ctrl-Shift-Enter)? Also note that
"Ted" does not equal "TED"; make sure your case matches.

Jerry

 

[Harlan Grove]

Did you array enter the formula (Ctrl-Shift-Enter)? . . .

Or switch to SUMPRODUCT which usually doesn't need to be array-entered.

. . . Also note that "Ted" does not equal "TED"; make sure your case matches.

Not true. Excel returns TRUE for the formula ="TED"="Ted", and this doesn't vary
with the transition formula evaluation setting. The = operator is
case-insensitive. Case-sensitive comparison requires using EXACT.

 

[timh2ofall]

Jerry, Yes, I did (Ctrl-Shift-Enter) and the case/spelling does match
on my workbook. It's not giving me the count of "Yes" in column C. Get
a #Value! error only.
Tim