How to count rows containg text in a table that has been filtered

[ddub25]

I am using this formula to count the number of rows with text in, but when I filter a column, the count still gives the original total.

=COUNTA(A20:A595)

How can I adapt this formula to only total the visible, filtered rows?

Dan

 

[Andrew Poulsom]

Try:

=SUBTOTAL(3,A20:A595)

 

[ddub25]

Thanks, Andrew.