I would use a database function:

=DCOUNTA(E3:F29,1,I1:J2)

Using this structu

E F I J
1 Col1 Col2
2 A Y
3 Col1 Col2
4 A Y
5 B A
6 C A
7 A Y
8 E A


Regards,
David Miller