Using the count function within subtotal on a filter list

[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.

 

[Gord Dibben]

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

 

[T. Valko]

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).

 

[Sean Timmons]

We can't do a COUNTIF with a SUBTOTAL. We may be able build a formula based