Because it is filtered for American only, of course you
can apply another filter for yes/no but given the OP
requirements it won't work unless you do that.
Of course it can be that the yes/no column is already filtered by something
else?

That formula will de-facto give you the opportunity to do a "countif"
of filtered values


--


Regards,


Peo Sjoblom

"Spiky" wrote in message
...
What about:
SUBTOTAL(3,range)

Not sure why this simple version wouldn't work, if Autofilter is being
used.