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!