Closed Thread
Results 1 to 3 of 3

Filtered Tables - Average and Sum

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    Version 1708
    Posts
    26

    Filtered Tables - Average and Sum

    I have a TABLE with data, and a set of Slicers to filter the data. On another SHEET I wish to display the AVERAGE of a column from the TABLE, whatever I do I seem to get the AVERAGE of the entire table rather than only that which is displayed via the filter. What am I doing wrong, Do I need a dynamic range, I thought this would be active seeing as the data is held within the TABLE

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,143

    Re: Filtered Tables - Average and Sum

    This is a duplicate thread - continue in your other thread.

    Pete

  3. #3
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,145

    Re: Filtered Tables - Average and Sum

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...e-and-sum.html
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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