Using the count function within subtotal on a filter list

  • Thread starter Thread starter Neil M
  • Start date Start date
N

Neil M

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.
 
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
 
If you filter on the column with Yes/No then all visible results will either
be all Yes or all No.

=SUBTOTAL(3,A2:A100)

If you filter on a different column and the Yes/No column displays both Yes
and No then it's more complicated. Post back if that's what you wanted to do
(and let us know the EXACT range to be counted).
 
Back
Top