Counting the results of a filtered list

N

Neal

Is there a way to count the number of rows displayed when
using Autofilter? The COUNT function displays the
complete (non-filtered) count. The COUNTIF function
returns the correct number but I don't want to have to
manually change the criteria argument each time I want to
change the filter.

Thanks
Neal
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
Counting Filtered Results Using Autofilter 2
Move between slides using Macros 0
count similar text with using filters 1
Counting Results of Formulas 1
Count Number of Rows 2
histogram dynamic bin count 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0

Top