+ Reply to Thread
Results 1 to 2 of 2

Summing a Field while Using an Autofilter

  1. #1
    Lost and Looking for Help
    Guest

    Summing a Field while Using an Autofilter

    I have a large spread sheet that i must sort. I currently am using an
    autofilter to sort the numbers, then copying the numbers to another sheet and
    then summing those numbers. I am doing this because when using the
    autofilter if you try and sum at the bottom of a column then you still sum
    all the values that are hidden. Is there a way to just sum the visible
    numbers when using the autofilter so that i can avoid having to copy and
    paste to another sheet. This is really slowing down my program.

  2. #2
    Tom Ogilvy
    Guest

    RE: Summing a Field while Using an Autofilter

    use
    =Subtotal(9,B2:B50)

    Subtotal only sums the visible rows from a filter.

    --
    Regards,
    Tom Ogilvy


    "Lost and Looking for Help" wrote:

    > I have a large spread sheet that i must sort. I currently am using an
    > autofilter to sort the numbers, then copying the numbers to another sheet and
    > then summing those numbers. I am doing this because when using the
    > autofilter if you try and sum at the bottom of a column then you still sum
    > all the values that are hidden. Is there a way to just sum the visible
    > numbers when using the autofilter so that i can avoid having to copy and
    > paste to another sheet. This is really slowing down my program.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1