Results 1 to 3 of 3

Thread: Median for Range: 2 Conditions

  1. #1

    Median for Range: 2 Conditions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?
    Last edited by PraveshG81; 2013-02-01 at 10:59 PM.

  2. #2
    + is an OR condition operator. Tr

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

  3. #3
    worked beautifully, thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •