+ Reply to Thread
Results 1 to 2 of 2

Median for Range: 2 Conditions

  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    14

    Median for Range: 2 Conditions

    Hello,

    I am trying to find the median of Column G IF any cell in Column N contain the text string "secondar" AND IF any cell in Column Q is greater then or equal to 2012.

    I have tried using two formulas but for some reason they are both finding the median only based on the second criteria, it is NOT taking the first criteria into account:

    (1) =MEDIAN(IF(((ISNUMBER(SEARCH("secondar",'GP Chart'!N1:N2000)))+('GP Chart'!Q1:Q2000>=2012)),'GP Chart'!G1:G2000))

    (2) =MEDIAN(IF((('GP Chart'!N1:N2000="*secondar*")+('GP Chart'!Q1:Q2000>=2012)),'GP Chart'!G1:G2000))

    Can someone please help me with this?

    Thank You!

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Median for Range: 2 Conditions

    {=MEDIAN(IF(ISNUMBER(SEARCH("Secondar",'GP Chart'!N1:N2000)),IF('GP Chart'!Q1:Q2000>=2012,'GP Chart'!G1:G2000)))}

    Array entered via Ctrl + Shift + Enter keys in combination
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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