Auto filter, sub totals, text

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

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
 
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)
 
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)
Click to expand...

Thanks I willl try that and let you know
 
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)
Click to expand...

Tried it, no joy. I am just needing the text label to populate the
name and not return a "0" or some other ref.
 
Back
Top