Auto filter, sub totals, text
 

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

Auto filter, sub totals, text
 

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
.

Auto filter, sub totals, text
 

On 13 Nov, 22:36, LMH wrote:
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
.

Thanks I willl try that and let you know

Auto filter, sub totals, text
 

On 13 Nov, 22:36, LMH wrote:
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
.

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

Auto filter, sub totals, text
 

On 14 Nov, 19:49, Johnnyboy5 wrote:
On 13 Nov, 22:36, LMH wrote:



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
.

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

This link to another post of mine has fix the problem

http://groups.google.co.uk/group/mic...86fd250?hl=en#