You don't say precisely what you are trying to achieve with your subtotal
I assume you are using it to show the number of rows visible after filtering.
So I'm guessing you are using SUBTOTAL(2,<range). (2 = COUNT)
If so, try SUBTOTAL(3,<range) for the columns containing text. (3 = COUNTA)
--
LMH


"Johnnyboy5" wrote:

I have a worksheet with two columns that have text in them (names,
area) the other columns are numbers, when I use the auto filter
function all the other columns can be made to work with the subtotal=
function, but I cant get the name or area to appear in the filter I
just get a "0"

any ideas

many thanks

Johnny
.