PraveshG81
New member
- Joined
- Oct 6, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
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?
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: