How can I show the total sum of items in a filtered column

=SUBTOTAL(9,A1:A100) will total just the visible cells.
Change range to suit.
I always put my formulae in a row above the headings.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
>

At one point I was able to see a number on the bottom of the page that would
automatically calculate the number of lines in the filtered subset.
So if there are 2000 lines of grocery items and I filter out chicken, I want
to know immeidately how many lines of chicken there are out of the 2000 lines
without physically counting rows........



"Roger Govier" wrote:

> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> Change range to suit.
> I always put my formulae in a row above the headings.
>
> --
> Regards
> Roger Govier
> "huckie" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

Then it sounds as if you want COUNT instead of SUM
Change the 9 to a 2
=SUBTOTAL(2,A1:A100)

1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 9=SUM
These tend to be the only variants I use, but look up Help on Subtotal to
see the complete list.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
> At one point I was able to see a number on the bottom of the page that
> would
> automatically calculate the number of lines in the filtered subset.
> So if there are 2000 lines of grocery items and I filter out chicken, I
> want
> to know immeidately how many lines of chicken there are out of the 2000
> lines
> without physically counting rows........
>
>
>
> "Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

huckie

If you are not seeing a count of records on the status bar see Debra
Dalgleish's site for reasons and workarounds.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben Excel MVP


On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
wrote:

>At one point I was able to see a number on the bottom of the page that would
>automatically calculate the number of lines in the filtered subset.
>So if there are 2000 lines of grocery items and I filter out chicken, I want
>to know immeidately how many lines of chicken there are out of the 2000 lines
>without physically counting rows........
>
>
>
>"Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

THANK YOU...it works for me now!

"Gord Dibben" wrote:

> huckie
>
> If you are not seeing a count of records on the status bar see Debra
> Dalgleish's site for reasons and workarounds.
>
> http://www.contextures.on.ca/xlautofilter02.html#Count
>
>
> Gord Dibben Excel MVP
>
>
> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
> wrote:
>
> >At one point I was able to see a number on the bottom of the page that would
> >automatically calculate the number of lines in the filtered subset.
> >So if there are 2000 lines of grocery items and I filter out chicken, I want
> >to know immeidately how many lines of chicken there are out of the 2000 lines
> >without physically counting rows........
> >
> >
> >
> >"Roger Govier" wrote:
> >
> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> >> Change range to suit.
> >> I always put my formulae in a row above the headings.
> >>
> >> --
> >> Regards
> >> Roger Govier
> >> "huckie" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >
> >>
> >>
> >>
>
>

Thanks for the feedback.

Gord

On Thu, 21 Jul 2005 11:09:04 -0700, huckie <[email protected]>
wrote:

>THANK YOU...it works for me now!
>
>"Gord Dibben" wrote:
>
>> huckie
>>
>> If you are not seeing a count of records on the status bar see Debra
>> Dalgleish's site for reasons and workarounds.
>>
>> http://www.contextures.on.ca/xlautofilter02.html#Count
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
>> wrote:
>>
>> >At one point I was able to see a number on the bottom of the page that would
>> >automatically calculate the number of lines in the filtered subset.
>> >So if there are 2000 lines of grocery items and I filter out chicken, I want
>> >to know immeidately how many lines of chicken there are out of the 2000 lines
>> >without physically counting rows........
>> >
>> >
>> >
>> >"Roger Govier" wrote:
>> >
>> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> >> Change range to suit.
>> >> I always put my formulae in a row above the headings.
>> >>
>> >> --
>> >> Regards
>> >> Roger Govier
>> >> "huckie" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >
>> >>
>> >>
>> >>
>>
>>

Thanks for the feedback.

Gord

On Thu, 21 Jul 2005 11:09:04 -0700, huckie <[email protected]>
wrote:

>THANK YOU...it works for me now!
>
>"Gord Dibben" wrote:
>
>> huckie
>>
>> If you are not seeing a count of records on the status bar see Debra
>> Dalgleish's site for reasons and workarounds.
>>
>> http://www.contextures.on.ca/xlautofilter02.html#Count
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
>> wrote:
>>
>> >At one point I was able to see a number on the bottom of the page that would
>> >automatically calculate the number of lines in the filtered subset.
>> >So if there are 2000 lines of grocery items and I filter out chicken, I want
>> >to know immeidately how many lines of chicken there are out of the 2000 lines
>> >without physically counting rows........
>> >
>> >
>> >
>> >"Roger Govier" wrote:
>> >
>> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> >> Change range to suit.
>> >> I always put my formulae in a row above the headings.
>> >>
>> >> --
>> >> Regards
>> >> Roger Govier
>> >> "huckie" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >
>> >>
>> >>
>> >>
>>
>>

THANK YOU...it works for me now!

"Gord Dibben" wrote:

> huckie
>
> If you are not seeing a count of records on the status bar see Debra
> Dalgleish's site for reasons and workarounds.
>
> http://www.contextures.on.ca/xlautofilter02.html#Count
>
>
> Gord Dibben Excel MVP
>
>
> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
> wrote:
>
> >At one point I was able to see a number on the bottom of the page that would
> >automatically calculate the number of lines in the filtered subset.
> >So if there are 2000 lines of grocery items and I filter out chicken, I want
> >to know immeidately how many lines of chicken there are out of the 2000 lines
> >without physically counting rows........
> >
> >
> >
> >"Roger Govier" wrote:
> >
> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> >> Change range to suit.
> >> I always put my formulae in a row above the headings.
> >>
> >> --
> >> Regards
> >> Roger Govier
> >> "huckie" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >
> >>
> >>
> >>
>
>

huckie

If you are not seeing a count of records on the status bar see Debra
Dalgleish's site for reasons and workarounds.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben Excel MVP


On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
wrote:

>At one point I was able to see a number on the bottom of the page that would
>automatically calculate the number of lines in the filtered subset.
>So if there are 2000 lines of grocery items and I filter out chicken, I want
>to know immeidately how many lines of chicken there are out of the 2000 lines
>without physically counting rows........
>
>
>
>"Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

Then it sounds as if you want COUNT instead of SUM
Change the 9 to a 2
=SUBTOTAL(2,A1:A100)

1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 9=SUM
These tend to be the only variants I use, but look up Help on Subtotal to
see the complete list.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
> At one point I was able to see a number on the bottom of the page that
> would
> automatically calculate the number of lines in the filtered subset.
> So if there are 2000 lines of grocery items and I filter out chicken, I
> want
> to know immeidately how many lines of chicken there are out of the 2000
> lines
> without physically counting rows........
>
>
>
> "Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

At one point I was able to see a number on the bottom of the page that would
automatically calculate the number of lines in the filtered subset.
So if there are 2000 lines of grocery items and I filter out chicken, I want
to know immeidately how many lines of chicken there are out of the 2000 lines
without physically counting rows........



"Roger Govier" wrote:

> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> Change range to suit.
> I always put my formulae in a row above the headings.
>
> --
> Regards
> Roger Govier
> "huckie" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

=SUBTOTAL(9,A1:A100) will total just the visible cells.
Change range to suit.
I always put my formulae in a row above the headings.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
>

Thanks for the feedback.

Gord

On Thu, 21 Jul 2005 11:09:04 -0700, huckie <[email protected]>
wrote:

>THANK YOU...it works for me now!
>
>"Gord Dibben" wrote:
>
>> huckie
>>
>> If you are not seeing a count of records on the status bar see Debra
>> Dalgleish's site for reasons and workarounds.
>>
>> http://www.contextures.on.ca/xlautofilter02.html#Count
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
>> wrote:
>>
>> >At one point I was able to see a number on the bottom of the page that would
>> >automatically calculate the number of lines in the filtered subset.
>> >So if there are 2000 lines of grocery items and I filter out chicken, I want
>> >to know immeidately how many lines of chicken there are out of the 2000 lines
>> >without physically counting rows........
>> >
>> >
>> >
>> >"Roger Govier" wrote:
>> >
>> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> >> Change range to suit.
>> >> I always put my formulae in a row above the headings.
>> >>
>> >> --
>> >> Regards
>> >> Roger Govier
>> >> "huckie" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >
>> >>
>> >>
>> >>
>>
>>

THANK YOU...it works for me now!

"Gord Dibben" wrote:

> huckie
>
> If you are not seeing a count of records on the status bar see Debra
> Dalgleish's site for reasons and workarounds.
>
> http://www.contextures.on.ca/xlautofilter02.html#Count
>
>
> Gord Dibben Excel MVP
>
>
> On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
> wrote:
>
> >At one point I was able to see a number on the bottom of the page that would
> >automatically calculate the number of lines in the filtered subset.
> >So if there are 2000 lines of grocery items and I filter out chicken, I want
> >to know immeidately how many lines of chicken there are out of the 2000 lines
> >without physically counting rows........
> >
> >
> >
> >"Roger Govier" wrote:
> >
> >> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> >> Change range to suit.
> >> I always put my formulae in a row above the headings.
> >>
> >> --
> >> Regards
> >> Roger Govier
> >> "huckie" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >
> >>
> >>
> >>
>
>

huckie

If you are not seeing a count of records on the status bar see Debra
Dalgleish's site for reasons and workarounds.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben Excel MVP


On Wed, 20 Jul 2005 13:44:01 -0700, huckie <[email protected]>
wrote:

>At one point I was able to see a number on the bottom of the page that would
>automatically calculate the number of lines in the filtered subset.
>So if there are 2000 lines of grocery items and I filter out chicken, I want
>to know immeidately how many lines of chicken there are out of the 2000 lines
>without physically counting rows........
>
>
>
>"Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

Then it sounds as if you want COUNT instead of SUM
Change the 9 to a 2
=SUBTOTAL(2,A1:A100)

1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 9=SUM
These tend to be the only variants I use, but look up Help on Subtotal to
see the complete list.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
> At one point I was able to see a number on the bottom of the page that
> would
> automatically calculate the number of lines in the filtered subset.
> So if there are 2000 lines of grocery items and I filter out chicken, I
> want
> to know immeidately how many lines of chicken there are out of the 2000
> lines
> without physically counting rows........
>
>
>
> "Roger Govier" wrote:
>
>> =SUBTOTAL(9,A1:A100) will total just the visible cells.
>> Change range to suit.
>> I always put my formulae in a row above the headings.
>>
>> --
>> Regards
>> Roger Govier
>> "huckie" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>>
>>
>>

At one point I was able to see a number on the bottom of the page that would
automatically calculate the number of lines in the filtered subset.
So if there are 2000 lines of grocery items and I filter out chicken, I want
to know immeidately how many lines of chicken there are out of the 2000 lines
without physically counting rows........



"Roger Govier" wrote:

> =SUBTOTAL(9,A1:A100) will total just the visible cells.
> Change range to suit.
> I always put my formulae in a row above the headings.
>
> --
> Regards
> Roger Govier
> "huckie" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

=SUBTOTAL(9,A1:A100) will total just the visible cells.
Change range to suit.
I always put my formulae in a row above the headings.

--
Regards
Roger Govier
"huckie" <[email protected]> wrote in message
news:[email protected]...
>