=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]...
>
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]...
>> >> >
>> >>
>> >>
>> >>
>>
>>
=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]...
>
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]...
>> >> >
>> >>
>> >>
>> >>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks