AutoFilter & Counting Displayed Results

  • Thread starter Thread starter David Lipetz
  • Start date Start date
D

David Lipetz

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.
 
Back
Top