+ Reply to Thread
Results 1 to 4 of 4

Need help to find average values of filtered results

  1. #1
    Registered User
    Join Date
    01-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    2

    Need help to find average values of filtered results

    Hi, I need some help figuring out some formulas.
    So I'm trying to set up some tables showing cost vs revenue of some marketing data. I'm setting up my tables on the first sheet and the data that I'm pulling from on the second. The data is organized by what source our clients came from, how much that source cost us and how much revenue the client contract generated.
    For my data I need to set up formulas that shows the average cost of each market, the total cost of each market, the average contract value and total contract value. Any idea on what formulas could work or any links to tutorials? It'd be much appreciated.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Need help to find average values of filtered results

    Hello,

    you should look into pivot tables and use slicers to filter the pivot tables. Pivot tables can calculate sums as well as averages and other aggregates.

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    01-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Need help to find average values of filtered results

    While that definitely looks like exactly what I need I'm missing the Analysis Toolpak to use slicers. I don't have the access to install it but I'll get my IT guy to get it done. I appreciate your help and if I have any more trouble with it I'll follow up. Thank you!

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Need help to find average values of filtered results

    Slicers are totally unrelated to the Analytics Toolpak. If you have Office 2013 you will have slicers for pivot tables. Just select a pivot table and on the Analyse ribbon click Insert Slicer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-12-2017, 05:41 PM
  2. Find average of last 24 hrs data from a filtered range based on a criteria
    By styldude in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2017, 05:18 AM
  3. [SOLVED] Multiple MAX results - find average?
    By surk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2016, 09:29 AM
  4. [SOLVED] How to select filtered values and copy the results using makros
    By chablo309 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2015, 09:34 AM
  5. How to select filtered values and copy the results using makros
    By chablo309 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2015, 09:14 AM
  6. [SOLVED] Using SUMPRODUCT and SUBTOTAL to count filtered results containing #N/A values
    By Powerslave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2013, 12:07 PM
  7. Replies: 1
    Last Post: 04-08-2012, 04:59 AM

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