Excel - subtotal filter count for character values

It is beneficial for me to create a row above a header row (with data field names) in a spreadsheet that contains a "SUBTOTAL" formula so when I include a data filter on the header row, I am able to have a count of how many rows are selected when I specify filter parameters.

Unfortunately, since it is a SUBTOTAL function, the count does not work on fields/columns that are character format.

Any suggestions on a similar method that would count filtered selections for both numeric and character?
exp vgAsked:
Who is Participating?
Wayne Taylor (webtubbs)Commented:
I assume you mean Text format, not Character format. If so, use COUNTA instead of COUNT, which is a function number of 3 or 103.

    =SUBTOTAL(3, A3:A300)

This will count all cells that are not empty.
exp vgAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.