Dynamic count on an Autofiltered list
 

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!

Dynamic count on an Autofiltered list
 

Use:

=Subtotal(3,your range)

best o luck

"ttbbgg" wrote:

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!

Dynamic count on an Autofiltered list
 

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.

"FARAZ QURESHI" wrote:

Use:

=Subtotal(3,your range)

best o luck

"ttbbgg" wrote:

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!

Dynamic count on an Autofiltered list
 

Use:

=Subtotal(3,your range)

best o luck

"ttbbgg" wrote:

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!