Spreadsheet: 87906d1287762779-counting-the-text-occurences-within-a-range-returns-incorrect-value-dividend
Sheet: Sheet1

Date | Open | High | Low | Close | Volume | Adj Close*
2010-10-20 00:00:00 | 110.09 | 111.58 | 109.82 | 111.09 | 7373600 | 111.09
2010-10-19 00:00:00 | 110.29 | 110.68 | 109.17 | 109.84 | 9253700 | 109.84
2010-10-18 00:00:00 | 110.68 | 111.59 | 110.55 | 111.01 | 4434900 | 111.01
2010-10-15 00:00:00 | 111.43 | 111.47 | 110.11 | 110.68 | 9377400 | 110.68
2010-10-15 00:00:00 | $ 0.093 Dividend
2010-10-14 00:00:00 | 111.05 | 111.23 | 110.31 | 111.07 | 8971700 | 110.98
2010-10-13 00:00:00 | 110.82 | 111.64 | 110.66 | 111.06 | 6921600 | 110.97
2010-10-12 00:00:00 | 109.93 | 110.63 | 109.21 | 110.26 | 5373500 | 110.17
2010-10-11 00:00:00 | 110.29 | 110.4 | 109.88 | 110.26 | 3527300 | 110.17
2010-10-08 00:00:00 | 109.66 | 110.41 | 109.38 | 110.16 | 4812900 | 110.07
2010-10-07 00:00:00 | 110.09 | 110.11 | 109.01 | 109.6 | 5282200 | 109.51
2010-10-06 00:00:00 | 109.44 | 109.83 | 109.27 | 109.77 | 7215600 | 109.68
2010-10-05 00:00:00 | 108.41 | 109.68 | 108.27 | 109.4 | 6493200 | 109.31
2010-10-04 00:00:00 | 108.16 | 108.55 | 107.07 | 107.57 | 5561600 | 107.48
2010-10-01 00:00:00 | 108.55 | 108.73 | 107.84 | 108.32 | 5987600 | 108.23
2010-09-30 00:00:00 | 108.91 | 109.52 | 107.47 | 107.91 | 11670500 | 107.82
2010-09-29 00:00:00 | 108.35 | 108.71 | 108 | 108.31 | 6281000 | 108.22
2010-09-28 00:00:00 | 108.36 | 108.87 | 107.3 | 108.56 | 7872700 | 108.47
2010-09-27 00:00:00 | 108.57 | 108.73 | 108.08 | 108.19 | 3989800 | 108.1
2010-09-24 00:00:00 | 107.77 | 108.66 | 107.67 | 108.57 | 5334900 | 108.48
2010-09-23 00:00:00 | 106.64 | 107.62 | 106.41 | 106.67 | 7547400 | 106.58
2010-09-22 00:00:00 | 107.56 | 108.04 | 107.08 | 107.4 | 5593500 | 107.31
2010-09-21 00:00:00 | 107.54 | 108.31 | 107.17 | 107.62 | 8381800 | 107.53
2010-09-20 00:00:00 | 106.4 | 107.72 | 106.2 | 107.52 | 5257500 | 107.43
2010-09-17 00:00:00 | 106.35 | 106.49 | 105.65 | 106.07 | 7777800 | 105.98
2010-09-17 00:00:00 | $ 0.191 Dividend
2010-09-16 00:00:00 | 105.67 | 106.24 | 105.4 | 106.19 | 5449000 | 105.91
2010-09-15 00:00:00 | 105.2 | 106.06 | 104.98 | 105.94 | 4374300 | 105.66
2010-09-14 00:00:00 | 105.48 | 106.07 | 105.17 | 105.44 | 5077800 | 105.16
2010-09-13 00:00:00 | 105.65 | 105.86 | 105.06 | 105.67 | 4944900 | 105.39
2010-09-10 00:00:00 | 104.42 | 104.82 | 104.15 | 104.78 | 3521600 | 104.5
2010-09-09 00:00:00 | 104.98 | 105 | 103.97 | 104.25 | 4396500 | 103.98
2010-09-08 00:00:00 | 103.71 | 104.4 | 103.68 | 103.98 | 5742100 | 103.71
2010-09-07 00:00:00 | 104.16 | 104.29 | 103.41 | 103.56 | 4206700 | 103.29
2010-09-03 00:00:00 | 104.22 | 104.63 | 103.29 | 104.58 | 6280300 | 104.3
2010-09-02 00:00:00 | 102.91 | 103.29 | 102.62 | 103.28 | 3782600 | 103.01
2010-09-01 00:00:00 | 101.36 | 102.9 | 101.33 | 102.8 | 8511100 | 102.53
2010-08-31 00:00:00 | 99.89 | 100.85 | 99.52 | 100.2 | 10523400 | 99.94
2010-08-30 00:00:00 | 101.23 | 101.54 | 100.16 | 100.17 | 4731200 | 99.91
2010-08-27 00:00:00 | 100.53 | 101.63 | 99.4 | 101.58 | 10431400 | 101.31
2010-08-26 00:00:00 | 100.96 | 101.06 | 99.67 | 99.93 | 8258800 | 99.67
2010-08-25 00:00:00 | 99.91 | 100.98 | 99.37 | 100.61 | 9732500 | 100.34
2010-08-24 00:00:00 | 100.73 | 101.15 | 99.91 | 100.4 | 9543400 | 100.14
2010-08-23 00:00:00 | 102.54 | 103.05 | 101.7 | 101.76 | 5552400 | 101.49
2010-08-20 00:00:00 | 102.43 | 102.48 | 101.47 | 102.14 | 8548600 | 101.87
2010-08-20 00:00:00 | $ 0.384 Dividend
2010-08-19 00:00:00 | 104.08 | 104.31 | 102.55 | 103.06 | 8882600 | 102.41
2010-08-18 00:00:00 | 104.26 | 105.11 | 103.68 | 104.57 | 6344900 | 103.91
2010-08-17 00:00:00 | 103.99 | 105.12 | 103.67 | 104.33 | 5461600 | 103.67
2010-08-16 00:00:00 | 102.81 | 103.59 | 102.38 | 103.28 | 5818900 | 102.62
2010-08-13 00:00:00 | 103.21 | 103.8 | 103.1 | 103.35 | 6481600 | 102.69
2010-08-12 00:00:00 | 102.85 | 103.87 | 102.78 | 103.45 | 14562800 | 102.79
2010-08-11 00:00:00 | 105.19 | 105.21 | 103.91 | 104.13 | 9496200 | 103.47
2010-08-10 00:00:00 | 106.36 | 107.18 | 105.67 | 106.66 | 8434400 | 105.98
2010-08-09 00:00:00 | 107 | 107.37 | 106.64 | 107.12 | 3723500 | 106.44
2010-08-06 00:00:00 | 105.92 | 106.73 | 105.31 | 106.69 | 7524700 | 106.01
2010-08-05 00:00:00 | 106.43 | 106.88 | 106.23 | 106.88 | 3631700 | 106.2
2010-08-04 00:00:00 | 106.65 | 107.15 | 106.38 | 106.96 | 7289900 | 106.28
2010-08-03 00:00:00 | 106.48 | 106.83 | 106.06 | 106.39 | 5440100 | 105.71
2010-08-02 00:00:00 | 106.08 | 106.99 | 105.88 | 106.73 | 6852300 | 106.05
2010-07-30 00:00:00 | 103.8 | 105.13 | 103.54 | 104.7 | 11706000 | 104.04
2010-07-29 00:00:00 | 105.66 | 105.93 | 103.92 | 104.67 | 11562800 | 104.01
2010-07-28 00:00:00 | 105.24 | 105.55 | 104.69 | 105.09 | 7157900 | 104.42
2010-07-27 00:00:00 | 105.75 | 105.84 | 105 | 105.44 | 10259500 | 104.77
2010-07-26 00:00:00 | 104.41 | 105.33 | 104.21 | 105.26 | 9047000 | 104.59
2010-07-23 00:00:00 | 103.11 | 104.5 | 102.92 | 104.27 | 13384300 | 103.61
2010-07-22 00:00:00 | 102.25 | 103.71 | 102.22 | 103.25 | 10386600 | 102.59
2010-07-21 00:00:00 | 102.67 | 102.7 | 100.72 | 101.23 | 10812500 | 100.59
2010-07-20 00:00:00 | 100.1 | 102.4 | 100.04 | 102.33 | 9200800 | 101.68
* Close price adjusted for dividends and splits.