+ Reply to Thread
Results 1 to 3 of 3

Trying to find median & average for multiple columns with multiple criteria

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    usa number 1
    MS-Off Ver
    2013
    Posts
    3

    Trying to find median & average for multiple columns with multiple criteria

    Hey friends,

    I am attempting to get the average and median, but i just cant write a winning formula. attached is the sample/dummy data and the spot where i need help is in the green transaction fundamentals table.

    The blue table above it is fine as is....for clarity, the blue table pulls all data from the right into it and in theory the green one is supposed to pull only the complete data (meaning data that has calculations in ever single "named title" column)

    cells C52:J53 are where i need help

    please help ease my jumbled brain

    i can try to clear it up more if i'm not making the most sense
    Book33.xlsx
    Last edited by help-meplease; 02-11-2016 at 11:32 AM.

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Trying to find median & average for multiple columns with multiple criteria

    Hi
    See the solution I propose
    1) Helper columns in CA:CQ - You can extend from CA5:CQ5 by copy down
    2) New table in B62:B86 to see the new formula that is based on AGGREGATE function
    3) C64:C69 can be extended to J64:J69

    See the file Book33.xlsx
    Note: You must adjust the range for your real data

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Trying to find median & average for multiple columns with multiple criteria

    Hi
    See the new version of the file where B62:J86 are fully completed.
    You only need expand the formulas in range CA5:EA5 to CA600:EA600.
    Book34.xlsx
    Regards

+ 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. Average with Multiple Criteria and on Different Columns
    By noskcire24 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-12-2015, 09:01 PM
  2. Replies: 0
    Last Post: 03-01-2015, 11:34 PM
  3. Average numbers from multiple columns based on multiple criteria
    By abambi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2015, 01:52 PM
  4. [SOLVED] If any combinations of multiple criteria met, then find average time elapsed
    By Verdant in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 01:57 AM
  5. YTD Median using Multiple Criteria
    By Decatur83 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2013, 09:00 AM
  6. Average GP from multiple columns with criteria
    By t+ccyco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2013, 07:06 PM
  7. [SOLVED] Average Based on Criteria in Multiple Columns
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 07-31-2012, 01:27 PM

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