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)
--
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
> .
>

On 13 Nov, 22:36, LMH <L...@discussions.microsoft.com> 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

On 13 Nov, 22:36, LMH <L...@discussions.microsoft.com> 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.

On 14 Nov, 19:49, Johnnyboy5 <intermediatec...@googlemail.com> wrote:
> On 13 Nov, 22:36, LMH <L...@discussions.microsoft.com> 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#