How do I use count, sum, or avg formulas on autofiltered results.

  • Thread starter Thread starter Hospice Volunteer Services
  • Start date Start date
H

Hospice Volunteer Services

When I attempt to use simple formulas on the displayed autofiltered results,
Excel includes cells hidden by the search. How do I get results on the
displayed cells only.
 
Hi,

Use Subtotal when working on filtered ranges, there's a full description in
Help.

Mike
 

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

Similar Threads

Counting Filtered Results Using Autofilter 2
Count the number of AutoFiltered records 6
Average over autofilter results 4
Counting Results of Formulas 1
How to use autofilter in excel with formula reference changing 1
formula displays as a formula, not as its result 1
How do I sum cells that have values from a text formula? 4
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl 2

Back
Top