When using the Excel AutoFilter, I would like to perform operations on the
filtered results displayed.
Some operations like AutoSum work (adding up only the filtered results
displayed), yet operations like COUNTA do not work.

How can I quickly count filtered results if COUNTA uses the entire range
rather than the filtererd results?

Thanks,
David

for countA in filtered result, please use:
=subtotal(3, Range)

"David Lipetz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When using the Excel AutoFilter, I would like to perform operations on the
> filtered results displayed.
> Some operations like AutoSum work (adding up only the filtered results
> displayed), yet operations like COUNTA do not work.
>
> How can I quickly count filtered results if COUNTA uses the entire range
> rather than the filtererd results?
>
> Thanks,
> David
>

Perfect! Thank you. Looks like the SUBTOTAL formula is something I should
spend some time learning more about.



"Bobocat" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> for countA in filtered result, please use:
> =subtotal(3, Range)
>
> "David Lipetz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> When using the Excel AutoFilter, I would like to perform operations on
>> the filtered results displayed.
>> Some operations like AutoSum work (adding up only the filtered results
>> displayed), yet operations like COUNTA do not work.
>>
>> How can I quickly count filtered results if COUNTA uses the entire range
>> rather than the filtererd results?
>>
>> Thanks,
>> David
>>
>
>