Dynamic count on an Autofiltered list

  • Thread starter Thread starter ttbbgg
  • Start date Start date
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!
 
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.
 
Back
Top