Count the Cells

[uaku]

Hi I have a large data on my excel spreadsheet. I use data>Filter>Auto Filter all the time.
Is it possible to count the number of rows after running auto filter on certain criteria. Here is the data

A B C D etc
Text1
Text2
Text3
etc

I use auto filer to show all the values for criteria meeting text1. How can I display a count on the top? When I change the criteria to "Text2" the count should change automatically.

Thanks for your help. I hope I managed to explain the problem well.

[Kenneth Hobs]

=SubTotal

[uaku]

=SubTotal

Thanks for your quick reply it worked great, is there any way I can show the criteria for sort as well so that I can form a message using Concatenante?

[Kenneth Hobs]

It is best to start a new thread for a new question. I don't know what you want. Try attaching a workbook with an example of what you want.