On Apr 27, 10:15 am, Dave Miller wrote:
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

Very interesting! Will have to do some research on this one. It
definitely doesn't work to just cut and paste it. When I have some
time....