MEDIAN IF range greater than and less than DATEs

[blbat]

I'm trying to use MEDIAN function on values in Column P that fall between Dates in Column O. Criteria in date range is IF greater than 03/31/2011 and LESS than 07/1/2011 Then select value in Column P. (I need to do this without using VBA.)

I have tried: (entered as an array)

 =IF(AND(DATE(O2:O299>20110331,O2:O299<20110701),MEDIAN(P2:P299)))

but get a "too few arguments" error.

The values below are what I'm working with, and the red highlights are the cells that meet the data selection criteria.

is there a way to do this? Thanks.

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 71px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>O</TD><TD>P</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>DATE</TD><TD>Val</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">3/10/2011</TD><TD style="TEXT-ALIGN: center">249</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">3/11/2009</TD><TD style="TEXT-ALIGN: center">192</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">8/6/2009</TD><TD style="TEXT-ALIGN: center">187</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">10/5/2009</TD><TD style="TEXT-ALIGN: center">157</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">12/3/2009</TD><TD style="TEXT-ALIGN: center">157</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">12/8/2009</TD><TD style="TEXT-ALIGN: center">151</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">12/15/2009</TD><TD style="TEXT-ALIGN: center">138</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">12/15/2009</TD><TD style="TEXT-ALIGN: center">138</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">12/15/2009</TD><TD style="TEXT-ALIGN: center">138</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">1/20/2010</TD><TD style="TEXT-ALIGN: center">132</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">2/16/2010</TD><TD style="TEXT-ALIGN: center">125</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">2/24/2010</TD><TD style="TEXT-ALIGN: center">119</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">3/11/2010</TD><TD style="TEXT-ALIGN: center">115</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">3/15/2010</TD><TD style="TEXT-ALIGN: center">115</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">3/17/2010</TD><TD style="TEXT-ALIGN: center">112</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">5/10/2010</TD><TD style="TEXT-ALIGN: center">104</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">5/27/2010</TD><TD style="TEXT-ALIGN: center">96</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">6/2/2010</TD><TD style="TEXT-ALIGN: center">90</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">7/6/2010</TD><TD style="TEXT-ALIGN: center">74</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">7/14/2010</TD><TD style="TEXT-ALIGN: center">74</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">7/19/2010</TD><TD style="TEXT-ALIGN: center">73</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">7/19/2010</TD><TD style="TEXT-ALIGN: center">63</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">7/19/2010</TD><TD style="TEXT-ALIGN: center">60</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">7/19/2010</TD><TD style="TEXT-ALIGN: center">60</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">7/19/2010</TD><TD style="TEXT-ALIGN: center">57</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">7/21/2010</TD><TD style="TEXT-ALIGN: center">56</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: right">9/17/2010</TD><TD style="TEXT-ALIGN: center">56</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: right">9/22/2010</TD><TD style="TEXT-ALIGN: center">54</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: right">10/22/2010</TD><TD style="TEXT-ALIGN: center">47</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: right">10/22/2010</TD><TD style="TEXT-ALIGN: center">33</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: right">10/28/2010</TD><TD style="TEXT-ALIGN: center">24</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: right">11/10/2010</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: right">11/10/2010</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: right">11/10/2010</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: right">11/16/2010</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: right">11/23/2010</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: right">11/29/2010</TD><TD style="TEXT-ALIGN: center">19</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: right">12/3/2010</TD><TD style="TEXT-ALIGN: center">19</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: right">12/3/2010</TD><TD style="TEXT-ALIGN: center">14</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: right">12/6/2010</TD><TD style="TEXT-ALIGN: center">14</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: right">12/14/2010</TD><TD style="TEXT-ALIGN: center">12</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: right">12/28/2010</TD><TD style="TEXT-ALIGN: center">12</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: right">1/13/2011</TD><TD style="TEXT-ALIGN: center">10</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: right">1/13/2011</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: right">1/24/2011</TD><TD style="TEXT-ALIGN: center">20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: right">1/27/2011</TD><TD style="TEXT-ALIGN: center">411</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: right">1/30/2011</TD><TD style="TEXT-ALIGN: center">405</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: right">2/9/2011</TD><TD style="TEXT-ALIGN: center">391</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: right">3/4/2011</TD><TD style="TEXT-ALIGN: center">375</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: right">3/8/2011</TD><TD style="TEXT-ALIGN: center">349</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="TEXT-ALIGN: right">3/8/2011</TD><TD style="TEXT-ALIGN: center">294</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD style="TEXT-ALIGN: right">3/8/2011</TD><TD style="TEXT-ALIGN: center">287</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD style="TEXT-ALIGN: right">3/8/2011</TD><TD style="TEXT-ALIGN: center">286</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD style="TEXT-ALIGN: right">3/9/2011</TD><TD style="TEXT-ALIGN: center">280</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD style="TEXT-ALIGN: right">3/9/2011</TD><TD style="TEXT-ALIGN: center">271</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD style="TEXT-ALIGN: right">3/14/2011</TD><TD style="TEXT-ALIGN: center">248</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD style="TEXT-ALIGN: right">3/18/2011</TD><TD style="TEXT-ALIGN: center">244</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD style="TEXT-ALIGN: right">3/28/2011</TD><TD style="TEXT-ALIGN: center">202</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">60</TD><TD style="TEXT-ALIGN: right">3/29/2011</TD><TD style="TEXT-ALIGN: center">175</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/5/2011</TD><TD style="TEXT-ALIGN: center">172</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">62</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/6/2011</TD><TD style="TEXT-ALIGN: center">166</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/12/2011</TD><TD style="TEXT-ALIGN: center">165</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">64</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/12/2011</TD><TD style="TEXT-ALIGN: center">161</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">65</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/15/2011</TD><TD style="TEXT-ALIGN: center">118</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">66</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">4/25/2011</TD><TD style="TEXT-ALIGN: center">105</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">67</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/24/2011</TD><TD style="TEXT-ALIGN: center">102</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">68</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/2/2011</TD><TD style="TEXT-ALIGN: center">89</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">69</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/4/2011</TD><TD style="TEXT-ALIGN: center">83</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">70</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/25/2011</TD><TD style="TEXT-ALIGN: center">82</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/10/2011</TD><TD style="TEXT-ALIGN: center">69</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">72</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/26/2011</TD><TD style="TEXT-ALIGN: center">63</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">73</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/6/2011</TD><TD style="TEXT-ALIGN: center">63</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">74</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/10/2011</TD><TD style="TEXT-ALIGN: center">55</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">75</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/2/2011</TD><TD style="TEXT-ALIGN: center">54</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/24/2011</TD><TD style="TEXT-ALIGN: center">53</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">77</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/24/2011</TD><TD style="TEXT-ALIGN: center">53</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">78</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/10/2011</TD><TD style="TEXT-ALIGN: center">49</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/24/2011</TD><TD style="TEXT-ALIGN: center">49</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">80</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/9/2011</TD><TD style="TEXT-ALIGN: center">49</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">81</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffc7ce; COLOR: #800080">5/5/2011</TD><TD style="TEXT-ALIGN: center">49</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">82</TD><TD style="TEXT-ALIGN: right">10/13/2009</TD><TD style="TEXT-ALIGN: center">45</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">83</TD><TD style="TEXT-ALIGN: right">1/29/2010</TD><TD style="TEXT-ALIGN: center">45</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">84</TD><TD style="TEXT-ALIGN: right">12/14/2010</TD><TD style="TEXT-ALIGN: center">41</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">85</TD><TD style="TEXT-ALIGN: right">1/11/2011</TD><TD style="TEXT-ALIGN: center">41</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">86</TD><TD style="TEXT-ALIGN: right">1/12/2011</TD><TD style="TEXT-ALIGN: center">32</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">87</TD><TD style="TEXT-ALIGN: right">1/25/2011</TD><TD style="TEXT-ALIGN: center">31</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">88</TD><TD style="TEXT-ALIGN: right">1/25/2011</TD><TD style="TEXT-ALIGN: center">21</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">89</TD><TD style="TEXT-ALIGN: right">2/4/2011</TD><TD style="TEXT-ALIGN: center">21</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">90</TD><TD style="TEXT-ALIGN: right">2/16/2011</TD><TD style="TEXT-ALIGN: center">21</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">91</TD><TD style="TEXT-ALIGN: right">2/17/2011</TD><TD style="TEXT-ALIGN: center">21</TD></TR></TBODY></TABLE>

 

[shift-del]

Hello

=MEDIAN(IF((O2:O91 > R2)*(O2:O91<r3),p2:p91))[ code]<b=""> < R3),P2:P91))

Array formula: Enter with CTRL-SHIFT-ENTER</r3),p291))[>

 

[blbat]

Thanks, but maybe I have not had enough coffee to wake up...

Where did the R2 and R3 come from? are those Cell references you want me to hard-key the date values into?

 

[blbat]

Disregard last post, I get the R2 and R3 are hardkeyed dates...

is there a way to do this with an actual date in the formula?

 

[barry houdini]

I'd suggest using DATE function like this, i.e.

=MEDIAN(IF(O2:O299 >DATE(2011,3,31),IF(O2:O299< DATE(2011,7,1),P2:P299)))

confirmed with CTRL+SHIFT+ENTER

 

[blbat]

!!!

Thanks so much barry houdini...your mad skills match your online handle.

Now that you have shown me the logical statement I am want to try to add another IF qualifier...
I have Column S S2:S299, contains the value of "1" or "O"

then I want only the value of P where S = 1

(The Second argument has the "<" symbol removed before DATE because it was messing with the UBB code somehow...)

=MEDIAN(IF(O2:O91>DATE(2011,3,31),IF(O2:O91DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<?XML:NAMESPACE PREFIX = DATE(2011,7,1),IF(S2 /><DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p>
 
<DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p><DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p>

</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<></DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<><DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p><DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p><DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))[ p CODE]<> but I get a #NUM! error...I must be pretty close!!
</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<>
</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<>
</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<>
</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))[>

 

[barry houdini]

You probably want this version

=MEDIAN(IF(O2:O91 >DATE(2011,3,31),IF(O2:O91< DATE(2011,7,1),IF(S2:S91=1,P2:P91))))

That asssumes that the 1s and zeroes in column S are numeric, not text. If they are text values then use quotes like "1"<DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))< p>

</DATE(2011,7,1),IF(S2:S91=ISNUMBER("1"),P2:P91))))<>

 

[blbat]

They are indeed numeric.

I will take some small consolation in how close I got!


Thank you again for the education.