Dynamic count on an Autofiltered list

T

ttbbgg

I have a large spreadsheet that has the Autofilter function engaged. I have
a summary section at the bottom of the sheet, and I want a Count section that
will change to the appropriate count number when an filter is engaged.
Example: I have 10 rows of data, composed of 4 occurences of A, 3 occurences
of B, and 3 occurences of C. When showing All in autofiltered mode, the
Count would show 10, however if I choose to view only A, then the count value
would change to 4. I believe there is a simple formula to accomplish this
but it escapes me. Help!
 
T

ttbbgg

Faraz;
Thanks so much, it works! I also discovered that using the Data, Lists
function will produce much the same results, and seems to use the same
formula as a result.
 

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