+ Reply to Thread
Results 1 to 2 of 2

Calculating median across many columns based on conditions in first column

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculating median across many columns based on conditions in first column

    Hello-

    I am trying to calculate median of many observations across columns based on attributes in the first column

    A B C D E
    Sam 17 23 40 93
    Sam 45 63 29 85
    Clark 52 34 74 60
    Clark 85 97 40 50
    Steve 80 62 75 32
    Sam 47 89 31 78
    Clark 94 70 38 82
    Steve 95 20 75 57

    For e.g., I want to write a formula which checks for "sam", and calculates median for all values in rows 2,3, and 7 (columns B-E).

    Can anyone please help me with this?

    Thx
    Rahul

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Calculating median across many columns based on conditions in first column

    Hi,

    Try this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER):

    =MEDIAN(IF($A$2:$A$9="Sam",$B$2:$E$9))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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. Calculating MEDIAN based on dynamically changing range
    By L.LEE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2013, 05:31 AM
  2. [SOLVED] Help figuring out $ in one column with conditions based on other columns
    By Alinkowski in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2013, 05:12 PM
  3. Replies: 3
    Last Post: 05-02-2012, 04:43 PM
  4. calculating MEDIAN with conditions, VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2012, 03:01 AM
  5. Calculating Column Based on 2 Other Columns
    By colugino in forum Excel General
    Replies: 4
    Last Post: 01-08-2009, 02:27 PM

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