Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Filters

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am using auto filter to clean up a file.
    Sometimes when I filter out a variable I get a little message in the lower left hand corner of the screen stating the number of records.
    Sometimes I don't.
    Any idea why?

    Also, how can I get the count of the records pulled up by the filter?

    Thanks

    Steve

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    generally im sure your right you should get the count, but seems can get lost and will again re oppear??? Excel floor i say...

    =COUNTIF(A1:A6,"<> 0")
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Better than countif is the subtotal function which is designed for use in Filters and grouping

    You have a number of options

    Subtotal(2,D2:D100) will count numbers in D2-D100

    Subtotal(3,D2:D100) will count characters in the range

    Subtotal(9,D2:D100) will give you the sum of the values in the displayed columns.

    There are 11 different values you can get these are the ones I use most...check out the Excel Help to get the others.



    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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