• 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


  • 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?


New Member

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?



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,



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