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,577

    Re: Filtered Tables - Average and Sum

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

    Pete

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

    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. filtered range from 2 tables
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2017, 12:30 AM
  2. Replies: 1
    Last Post: 06-17-2015, 03:35 PM
  3. [SOLVED] Filtered Average
    By sick stigma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-24-2012, 11:40 PM
  4. Naming cells in filtered tables
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2010, 02:15 PM
  5. Excel 2007 : Filtered lookups for chart tables
    By smudgepost in forum Excel General
    Replies: 0
    Last Post: 07-02-2010, 08:52 AM
  6. [SOLVED] Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 AM

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