Can I set a cell value to a filter selection in Excel?

T

TC in CT

I have auto filter on for a set of row headers and would like to populate a
cell with the number of rows that match the filter selection. If my row
entries in this column are "Yes" and "No", for example, I'd like to show the
number of "Yes" entries in the column when I filter by "Yes" or "No" when
filtered by "No".

A pivot table is over kill for my solution.

Thanks in advance!!
 
R

ryguy7272

Let's say 'Response' is in A1.
all the Yes and No responses are in A2:A30.
=SUBTOTAL(3,A2:A30)
Filter your list and see what happens.


Regards,
Ryan--
 
T

TC in CT

You nailed it rguy!! Thanks.

ryguy7272 said:
Let's say 'Response' is in A1.
all the Yes and No responses are in A2:A30.
=SUBTOTAL(3,A2:A30)
Filter your list and see what happens.


Regards,
Ryan--
 
K

Ken

I searched and found this formula and works as it's noted below, however, so
I can learn how this is done instead of copying, can you tell me what the 3,
reference represents in the formula?
 
T

T. Valko

Look in Excel help for the SUBTOTAL function. It'll tell you what all the
index numbers mean.
 
G

Gord Dibben

You can learn more by typing "subtotal" into the Excel help dialog.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top