=COUNTIF(E3:E29,"A")+COUNTIF(F3:F29,"Y")

"davegb" wrote:

I want a count based on 2 criteria in columns E & F in rows 3 to 29 in
the sheet. For example, I want to sum the number of times where both
an "A" occurs in column E and a "y" occurs in column F. I understand
that this would require an array formula, but haven't worked with them
much and don't really understand them at all. Can someone suggest the
formula for doing this?
Thanks!