• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count rows after using autofilter?

jollyroger

New Member
Hi,

Just found this site it is great.

If I have rows of data and I use auotfilter. I want to count the number of rows that display when I select something using the filter. I want the number to appear under the last row that is found. How can I do this?


Thanks
 

keymaster

New Member
assuming the list in range A1:A10, in cell A12 (you should leave a blank cell, otherwise excel applies filter to this cell as well) write the formula,


=subtotal(2,a1:a10)
 

Hui

Excel Ninja
Staff member
If the data contains alpha characters not just numbers you probably should use =subtotal(3,a1:a10) or

=subtotal(103,a1:a10)
 
Top