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