Results 1 to 3 of 3
  1. #1
    DonS
    Guest

    Autofilter & Summing

    Using Excel 97 or NT Workstation.

    I am unable to use autofilter and have a sum of only the displayed records. I always get the sum of the entire column when I only want the sum of the values displayed in that column.

    I am aware of COUNTA that will count what is displayed but am unaware of any similar function in SUM.

    TIA - DonS

  2. #2
    New Lounger
    Join Date
    Sep 2002
    Location
    London, Gtr London, England
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autofilter & Summing

    It sounds like you need to use subtotal. This takes the format 'SUBTOTAL(function_num,ref1,ref2,

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Autofilter & Summing

    I think you may be looking for SUMIF
    David Grugeon
    Brisbane Australia

Posting Permissions

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