Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting a Count when using Autofilter (2003)

    Greetings,

    I have a need to display the count of information when using the autofilter. What I would like to do is, display on the spreadsheet the count of items listed AFTER I have selected something from the dropdown in a filter selection list.

    I tried using the count function, but that only counted the entire list of items, not the displayed items.


    Any Ideas?

    Thanks,
    Brad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting a Count when using Autofilter (2003)

    You can use the SUBTOTAL function for this, with 3 (count of arguments) or 2 (count of numbers) as first argument, e.g.

    =SUBTOTAL(3,A2:A100)

    The formula will be recalculated automatically when you apply a filter.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting a Count when using Autofilter (2003)

    Very slick.....



    thanks,
    Brad

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting a Count when using Autofilter (2003)

    <P ID="edit" class=small>(Edited by Jezza on 21-Feb-08 17:29. Opps I assumed Sum not CountA, changed to reflect this)</P>Hi Brad

    You can use the Subtotal Function

    In the last row of your data type this formula

    =SUBTOTAL(3,B2:B100)

    The 3 depicts the CountA of the cells visible
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •