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

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

--
Biff
Microsoft Excel MVP


"Neil M" <Neil wrote in message
...
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.

You can use below formula while using filter .... 103 will ignore hidden
values and only count unhidden value .......

=SUBTOTAL(103,A2:A100)


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98893

We can't do a COUNTIF with a SUBTOTAL. We may be able build a formula based
on the data you are filtering.

"Neil M" 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.