See help on Subtotal function for a list of the numbers used in the
argument.

There are 11 possible arguments............2 is count.


Gord Dibben MS Excel MVP


On Thu, 21 May 2009 08:21:01 -0700, Neil M <Neil
wrote:

I have a column of data with either "Yes" or "No" (100 rows) and want to use
the subtotal function with the count criteria for the number of "yes" or "no"
when I filter. Please help, thanks.