Count rows after using autofilter?

[jollyroger]

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]

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]

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

=subtotal(103,a1:a10)