Ranged countif and sumif criteria

[Cantfigureitout]

I'm trying to figure out how to find out how to make the countif and sum if functions work for a table that uses cash values. I want excel to count records in a column that are greater then X but less then Y. I have used the help function and it says to use this: =countif(E:E,">5"&"<=10")
When I do hit enter it just reads 1. I know there is more then one record but it keeps doing that.

As for the sumif I want essentially the same criteria. I want to say whats the total value of things in column E that are ">5"&"<=10".

What formula do I need to use?

 

[Jonmo1]

Welcome to the board...

One way is to count how many are greater than 5, and from that, subtract those that are greater than 10...

=countif(E:E,">5")-countif(E:E,">10")

Hope that helps...

 

[Cantfigureitout]

Thank you :P
And Ill give that a shot... how would you suggest doing the sumif? any ideas?

Edit: now that I think about it... will that work? Heres an ex of what I'm working with and what I need to make
Large set of prices:
<table x:str="" style="border-collapse: collapse; width: 49pt;" width="65" border="0" cellpadding="0" cellspacing="0"><col style="width: 49pt;" width="65"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; width: 49pt;" width="65" height="17">Sale_Price</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" x:num="147.72" height="17">$147.72</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="146.78" height="17">$146.78</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="144" height="17">$144.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="130.31" height="17">$130.31</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="129.85" height="17">$129.85</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="129.18" height="17">$129.18</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="128.7" height="17">$128.70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="128.32" height="17">$128.32</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="128.23" height="17">$128.23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="127.53" height="17">$127.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="120" height="17">$120.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="118.95" height="17">$118.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="115.44" height="17">$115.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="114.36" height="17">$114.36</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="112.8" height="17">$112.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="111.05" height="17">$111.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="108.83" height="17">$108.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="108.68" height="17">$108.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="108.07" height="17">$108.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="107.99" height="17">$107.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="107.78" height="17">$107.78</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="107.46" height="17">$107.46</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="107.28" height="17">$107.28</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="106.95" height="17">$106.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="105.9" height="17">$105.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="105.12" height="17">$105.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="104.63" height="17">$104.63</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="104.08" height="17">$104.08</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="104.08" height="17">$104.08</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="103.74" height="17">$103.74</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="103.74" height="17">$103.74</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="100.8" height="17">$100.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="100.69" height="17">$100.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="100.44" height="17">$100.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="100.41" height="17">$100.41</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="100.24" height="17">$100.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="99.86" height="17">$99.86</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="99.79" height="17">$99.79</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="99.26" height="17">$99.26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="98.53" height="17">$98.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="98.02" height="17">$98.02</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="97.76" height="17">$97.76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="97.5" height="17">$97.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="97.45" height="17">$97.45</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="97.03" height="17">$97.03</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="94.88" height="17">$94.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="94.88" height="17">$94.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="94.88" height="17">$94.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="94.06" height="17">$94.06</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="92.5" height="17">$92.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="91.98" height="17">$91.98</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="91.34" height="17">$91.34</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="91.02" height="17">$91.02</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="90.43" height="17">$90.43</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="89.99" height="17">$89.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="89.81" height="17">$89.81</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="89.54" height="17">$89.54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="88.55" height="17">$88.55</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="88" height="17">$88.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="87.48" height="17">$87.48</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="86.93" height="17">$86.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="85.47" height="17">$85.47</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="84.22" height="17">$84.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="84" height="17">$84.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="83.8" height="17">$83.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="83.61" height="17">$83.61</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="81.89" height="17">$81.89</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="81.19" height="17">$81.19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="81.04" height="17">$81.04</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="80.97" height="17">$80.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="80.69" height="17">$80.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="80" height="17">$80.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="79.97" height="17">$79.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="77.37" height="17">$77.37</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="76.47" height="17">$76.47</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="76.33" height="17">$76.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="76.03" height="17">$76.03</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="75.9" height="17">$75.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="75" height="17">$75.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="75" height="17">$75.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="75" height="17">$75.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="74.92" height="17">$74.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="74.91" height="17">$74.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="74.49" height="17">$74.49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="73.5" height="17">$73.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="73.16" height="17">$73.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="72.87" height="17">$72.87</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="72" height="17">$72.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="70.12" height="17">$70.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="69.97" height="17">$69.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="69.36" height="17">$69.36</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="69" height="17">$69.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="68.76" height="17">$68.76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="68.13" height="17">$68.13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="68.11" height="17">$68.11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.93" height="17">$67.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.9" height="17">$67.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.9" height="17">$67.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.9" height="17">$67.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.9" height="17">$67.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.9" height="17">$67.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.81" height="17">$67.81</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.68" height="17">$67.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.26" height="17">$67.26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="67.03" height="17">$67.03</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="66.91" height="17">$66.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="66.48" height="17">$66.48</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="65.53" height="17">$65.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="64.54" height="17">$64.54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.77" height="17">$62.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.5" height="17">$62.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.34" height="17">$62.34</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="62.33" height="17">$62.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="61.9" height="17">$61.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="61.6" height="17">$61.60</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="61.19" height="17">$61.19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="60.43" height="17">$60.43</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="60" height="17">$60.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="59.76" height="17">$59.76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="59.36" height="17">$59.36</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="59.15" height="17">$59.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="59.14" height="17">$59.14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="59.02" height="17">$59.02</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="58.66" height="17">$58.66</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="57.31" height="17">$57.31</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.48" height="17">$56.48</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.4" height="17">$56.40</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.31" height="17">$56.31</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.19" height="17">$56.19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.09" height="17">$56.09</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="56.06" height="17">$56.06</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="55.93" height="17">$55.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="55.92" height="17">$55.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="55.68" height="17">$55.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="55.68" height="17">$55.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="55.68" height="17">$55.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.99" height="17">$54.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.75" height="17">$54.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.72" height="17">$54.72</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.68" height="17">$54.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.42" height="17">$54.42</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="54.1" height="17">$54.10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="53.2" height="17">$53.20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="52.96" height="17">$52.96</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="52.95" height="17">$52.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="51.42" height="17">$51.42</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50.76" height="17">$50.76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50.56" height="17">$50.56</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50.34" height="17">$50.34</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50.24" height="17">$50.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50" height="17">$50.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="50" height="17">$50.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="49.95" height="17">$49.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="49.74" height="17">$49.74</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="49.49" height="17">$49.49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="49.24" height="17">$49.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.93" height="17">$48.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.93" height="17">$48.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.64" height="17">$48.64</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.53" height="17">$48.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.17" height="17">$48.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="48.14" height="17">$48.14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="47.88" height="17">$47.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="47.5" height="17">$47.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="47.19" height="17">$47.19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="46.97" height="17">$46.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="46.49" height="17">$46.49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45.81" height="17">$45.81</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45.4" height="17">$45.40</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45.38" height="17">$45.38</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45.27" height="17">$45.27</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45" height="17">$45.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45" height="17">$45.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="45" height="17">$45.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="44.77" height="17">$44.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="44.58" height="17">$44.58</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="44.54" height="17">$44.54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="44.24" height="17">$44.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="43.95" height="17">$43.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="43.21" height="17">$43.21</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="42.99" height="17">$42.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="42.94" height="17">$42.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="42.57" height="17">$42.57</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="42.49" height="17">$42.49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="41.02" height="17">$41.02</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="41" height="17">$41.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40.76" height="17">$40.76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40.44" height="17">$40.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40.39" height="17">$40.39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40.39" height="17">$40.39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40.11" height="17">$40.11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="40" height="17">$40.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="39.9" height="17">$39.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="39.7" height="17">$39.70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="39" height="17">$39.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="38.67" height="17">$38.67</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="38.44" height="17">$38.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="38.27" height="17">$38.27</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="37.96" height="17">$37.96</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="37.93" height="17">$37.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="37.63" height="17">$37.63</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="37.05" height="17">$37.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="37" height="17">$37.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36.88" height="17">$36.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36.63" height="17">$36.63</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36.1" height="17">$36.10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36.07" height="17">$36.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36.07" height="17">$36.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36" height="17">$36.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="36" height="17">$36.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="35.5" height="17">$35.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="35" height="17">$35.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="34.78" height="17">$34.78</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="34.53" height="17">$34.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="34.33" height="17">$34.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="34.06" height="17">$34.06</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="34" height="17">$34.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.83" height="17">$33.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.83" height="17">$33.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.65" height="17">$33.65</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.39" height="17">$33.39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.37" height="17">$33.37</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.35" height="17">$33.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.35" height="17">$33.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.22" height="17">$33.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33.01" height="17">$33.01</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="33" height="17">$33.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="32.98" height="17">$32.98</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="32.4" height="17">$32.40</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="32.17" height="17">$32.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="32.11" height="17">$32.11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="32.11" height="17">$32.11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.97" height="17">$31.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.97" height="17">$31.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.97" height="17">$31.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.83" height="17">$31.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.63" height="17">$31.63</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.6" height="17">$31.60</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.16" height="17">$31.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="31.04" height="17">$31.04</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30.94" height="17">$30.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30.8" height="17">$30.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30.79" height="17">$30.79</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30.53" height="17">$30.53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30.17" height="17">$30.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="30" height="17">$30.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="29.99" height="17">$29.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="29.92" height="17">$29.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="29.61" height="17">$29.61</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="29.39" height="17">$29.39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.99" height="17">$28.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.99" height="17">$28.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.99" height="17">$28.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.9" height="17">$28.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.9" height="17">$28.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.88" height="17">$28.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.88" height="17">$28.88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.65" height="17">$28.65</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.52" height="17">$28.52</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="28.05" height="17">$28.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="27.99" height="17">$27.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="27.15" height="17">$27.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.86" height="17">$26.86</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.77" height="17">$26.77</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.75" height="17">$26.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.63" height="17">$26.63</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.56" height="17">$26.56</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.22" height="17">$26.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.22" height="17">$26.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="26.22" height="17">$26.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25.75" height="17">$25.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25.74" height="17">$25.74</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25.6" height="17">$25.60</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25.59" height="17">$25.59</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25" height="17">$25.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="25" height="17">$25.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="24.92" height="17">$24.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="24.79" height="17">$24.79</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="24.79" height="17">$24.79</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="23.94" height="17">$23.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="23.35" height="17">$23.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="23.28" height="17">$23.28</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="22.82" height="17">$22.82</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="22.7" height="17">$22.70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="22.7" height="17">$22.70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="22" height="17">$22.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.9" height="17">$21.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.84" height="17">$21.84</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.75" height="17">$21.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.51" height="17">$21.51</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.46" height="17">$21.46</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.16" height="17">$21.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.16" height="17">$21.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="21.12" height="17">$21.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="20.66" height="17">$20.66</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="20.48" height="17">$20.48</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="20.15" height="17">$20.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="20.04" height="17">$20.04</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="19.92" height="17">$19.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="19.86" height="17">$19.86</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="19.8" height="17">$19.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="19.29" height="17">$19.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="19.17" height="17">$19.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.99" height="17">$18.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.91" height="17">$18.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.71" height="17">$18.71</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.71" height="17">$18.71</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.59" height="17">$18.59</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.59" height="17">$18.59</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.5" height="17">$18.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.45" height="17">$18.45</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.45" height="17">$18.45</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18.21" height="17">$18.21</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="18" height="17">$18.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="17.91" height="17">$17.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="17.74" height="17">$17.74</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="17.56" height="17">$17.56</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="17.38" height="17">$17.38</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="16.92" height="17">$16.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="16.87" height="17">$16.87</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="16.49" height="17">$16.49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="15.94" height="17">$15.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="15.62" height="17">$15.62</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.99" height="17">$14.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.99" height="17">$14.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.54" height="17">$14.54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.29" height="17">$14.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.29" height="17">$14.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14.23" height="17">$14.23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="14" height="17">$14.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.99" height="17">$13.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.56" height="17">$13.56</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.51" height="17">$13.51</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.33" height="17">$13.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.33" height="17">$13.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="13.08" height="17">$13.08</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.99" height="17">$12.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.99" height="17">$12.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.84" height="17">$12.84</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.52" height="17">$12.52</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.29" height="17">$12.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.29" height="17">$12.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.25" height="17">$12.25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="12.05" height="17">$12.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.98" height="17">$11.98</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.97" height="17">$11.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.96" height="17">$11.96</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.83" height="17">$11.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.83" height="17">$11.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.83" height="17">$11.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.83" height="17">$11.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.83" height="17">$11.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.75" height="17">$11.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.69" height="17">$11.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.57" height="17">$11.57</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.44" height="17">$11.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.35" height="17">$11.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.35" height="17">$11.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.24" height="17">$11.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.24" height="17">$11.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.24" height="17">$11.24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.17" height="17">$11.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.16" height="17">$11.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.15" height="17">$11.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="11.06" height="17">$11.06</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.94" height="17">$10.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.92" height="17">$10.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.57" height="17">$10.57</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.2" height="17">$10.20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="10.03" height="17">$10.03</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.99" height="17">$9.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.94" height="17">$9.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.92" height="17">$9.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.85" height="17">$9.85</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.79" height="17">$9.79</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.78" height="17">$9.78</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.58" height="17">$9.58</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.26" height="17">$9.26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="9.05" height="17">$9.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.95" height="17">$8.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.91" height="17">$8.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.85" height="17">$8.85</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.8" height="17">$8.80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.75" height="17">$8.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.72" height="17">$8.72</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.4" height="17">$8.40</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.29" height="17">$8.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.13" height="17">$8.13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.12" height="17">$8.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8.01" height="17">$8.01</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="8" height="17">$8.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.95" height="17">$7.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.9" height="17">$7.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.89" height="17">$7.89</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.27" height="17">$7.27</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.27" height="17">$7.27</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.2" height="17">$7.20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.15" height="17">$7.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.12" height="17">$7.12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.11" height="17">$7.11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7.1" height="17">$7.10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="7" height="17">$7.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.99" height="17">$6.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.99" height="17">$6.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.92" height="17">$6.92</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.9" height="17">$6.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.9" height="17">$6.90</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.83" height="17">$6.83</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.57" height="17">$6.57</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.46" height="17">$6.46</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.35" height="17">$6.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.22" height="17">$6.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.07" height="17">$6.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.07" height="17">$6.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="6.07" height="17">$6.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.91" height="17">$5.91</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.85" height="17">$5.85</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.69" height="17">$5.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.69" height="17">$5.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.69" height="17">$5.69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.68" height="17">$5.68</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.62" height="17">$5.62</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.58" height="17">$5.58</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.5" height="17">$5.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.36" height="17">$5.36</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.25" height="17">$5.25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.23" height="17">$5.23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.23" height="17">$5.23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.21" height="17">$5.21</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.08" height="17">$5.08</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.07" height="17">$5.07</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5.05" height="17">$5.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="5" height="17">$5.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.96" height="17">$4.96</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.94" height="17">$4.94</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.72" height="17">$4.72</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.66" height="17">$4.66</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.55" height="17">$4.55</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.54" height="17">$4.54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.5" height="17">$4.50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.45" height="17">$4.45</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.42" height="17">$4.42</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.39" height="17">$4.39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.35" height="17">$4.35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.34" height="17">$4.34</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.22" height="17">$4.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.17" height="17">$4.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.16" height="17">$4.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.16" height="17">$4.16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="4.15" height="17">$4.15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.95" height="17">$3.95</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.93" height="17">$3.93</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.82" height="17">$3.82</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.78" height="17">$3.78</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.75" height="17">$3.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.38" height="17">$3.38</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.3" height="17">$3.30</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.29" height="17">$3.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.29" height="17">$3.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.29" height="17">$3.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.29" height="17">$3.29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.25" height="17">$3.25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="3.22" height="17">$3.22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.99" height="17">$2.99</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.98" height="17">$2.98</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.97" height="17">$2.97</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.75" height="17">$2.75</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.71" height="17">$2.71</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.59" height="17">$2.59</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.51" height="17">$2.51</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.47" height="17">$2.47</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.43" height="17">$2.43</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.37" height="17">$2.37</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="2.05" height="17">$2.05</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" x:num="1.21" height="17">$1.21</td> </tr> </tbody></table>

Then I need to have it count and sum for the following <5, 5.01-10, 10.01 –20, 20.01-30, 30.01-45, 45.01-60, 60.01-80, 80.01-100, 100.01-130, 130.01-150, 150+

 

[Jonmo1]

The same way...

just change countif to sumif

 

[Cantfigureitout]

I tried that formula and It gave me some really odd numbers (since it was adding every value above it and everything below it there was a lot of info that shouldn't be there) but It did give me an idea. This is what I did and it worked out
<table x:str="" style="border-collapse: collapse; width: 576pt;" width="768" border="0" cellpadding="0" cellspacing="0"><col style="width: 144pt;" width="192"> <col style="width: 159pt;" width="212"> <col style="width: 273pt;" width="364"> <tbody><tr style="height: 13.5pt;" height="18"> <td class="xl26" style="height: 13.5pt; width: 144pt;" width="192" height="18">
</td> <td class="xl27" style="width: 159pt;" width="212">Number of sales</td> <td class="xl27" style="border-left: medium none; width: 273pt;" width="364">Total value</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">$4.99 or less</td> <td class="xl31" style="width: 159pt;" x:num="42" width="212">=COUNTIF('Daily Report'!F:F,"<5")</td> <td class="xl28" style="border-left: medium none; width: 273pt;" x:num="151.25" width="364">=SUMIF('Daily Report'!F:F,"<5",'Daily Report'!F:F)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="border-top: medium none; height: 12.75pt;" x:num="" height="17">5</td> <td class="xl31" style="border-top: medium none; width: 159pt;" x:num="9" width="212">=COUNTIF('Daily Report'!F:F,"=5")</td> <td class="xl28" style="border-top: medium none; border-left: medium none; width: 273pt;" x:num="45" width="364">=SUMIF('Daily Report'!F:F,"=5",'Daily Report'!F:F)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="border-top: medium none; height: 12.75pt;" height="17">$5.01-10</td> <td class="xl31" style="border-top: medium none; width: 159pt;" x:num="62" width="212">=COUNTIF('Daily Report'!F:F,"<=10")-SUM('Quick facts'!F48:F49)</td> <td class="xl28" style="border-top: medium none; border-left: medium none; width: 273pt;" x:num="448.08" width="364">=SUMIF('Daily Report'!F:F,"<=10")-SUM('Quick facts'!G48:G49)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="border-top: medium none; height: 12.75pt;" height="17">$10.01-20</td> <td class="xl31" style="border-top: medium none; width: 159pt;" x:num="79" width="212">=COUNTIF('Daily Report'!F:F,"<=20")-SUM('Quick facts'!F48:F50)</td> <td class="xl28" style="border-top: medium none; border-left: medium none; width: 273pt;" x:num="1108.5" width="364">=SUMIF('Daily Report'!F:F,"<=20")-SUM('Quick facts'!G48:G50)</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl29" style="border-top: medium none; height: 13.5pt;" height="18">$20.01+</td> <td class="xl31" style="border-top: medium none; width: 159pt;" x:num="308" width="212">=COUNTIF('Daily Report'!F:F,">20")</td> <td class="xl28" style="border-top: medium none; border-left: medium none; width: 273pt;" x:num="18025.13" width="364">=SUMIF('Daily Report'!F:F,">20",'Daily Report'!F:F)</td> </tr> </tbody></table>