Spreadsheet: 106656d1303878878-summing-the-number-of-ma-crosses-linecrossesfunction
Sheet: Sheet1

Series | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here are my answers of Crosses
2011-03-01 00:00:00 | 74.38309999999998 | 96.19080000000002 | 138.0255 | 42.3621 | 125.1925 | 93.32159999999999 | 40.38560000000001 | 170.5739 | 147.5914 | 32.02099999999999 | 160.4244 | 167.7047 | 114.7687 | 41.8347 | 138.5529 | 29.00169999999997 | 2.869200000000035 | 55.80520000000001 | 179.6124 | 12.833 | 44.70390000000003 | 97.63990000000001 | 167.5546 | 135.6837 | 82.74770000000001 | 31.87090000000001 | 84.80689999999998 | 52.93599999999998 | 120.0297 | 165.5872 | 23.83889999999997 | 17.99580000000003 | 162.3918 | 5.162800000000004 | 26.7081 | 79.64409999999998
2011-03-02 00:00:00 | 74.97410000000002 | 95.23069999999998 | 136.5224 | 43.92400000000001 | 123.6083 | 91.7327 | 38.79639999999998 | 170.2048 | 148.5035 | 31.05010000000001 | 161.4176 | 166.7068 | 113.7705 | 41.29169999999999 | 139.1547 | 28.37760000000003 | 3.49799999999999 | 56.43430000000001 | 179.5536 | 12.9141 | 44.78969999999998 | 97.726 | 167.5323 | 135.6567 | 82.72039999999998 | 31.87560000000002 | 84.81190000000004 | 52.93630000000002 | 123.115 | 161.9109 | 27.8843 | 13.4074 | 167.039 | 0.4933000000000334 | 31.38229999999999 | 84.3186 |  | 8
2011-03-03 00:00:00 | 75.565 | 94.2712 | 135.0199 | 45.4853 | 122.0248 | 90.14439999999999 | 37.20779999999999 | 169.8362 | 149.4151 | 30.0797 | 162.4102 | 165.7094 | 112.7728 | 40.74870000000004 | 139.7565 | 27.75360000000001 | 4.126800000000003 | 57.0634 | 179.4948 | 12.9951 | 44.87550000000005 | 97.81210000000004 | 167.5101 | 135.6297 | 82.69309999999999 | 31.88040000000001 | 84.81700000000001 | 52.9366 | 126.3469 | 158.0881 | 32.07570000000004 | 8.673 | 171.8322 | 4.3221 | 36.20250000000004 | 89.13910000000004 |  | 13
2011-03-04 00:00:00 | 76.15559999999999 | 93.3126 | 133.5182 | 47.04589999999999 | 120.442 | 88.55690000000001 | 35.6199 | 169.4682 | 150.3262 | 29.1097 | 163.4024 | 164.7125 | 111.7755 | 40.2056 | 140.3585 | 27.12939999999998 | 4.75569999999999 | 57.6927 | 179.4359 | 13.0762 | 44.96129999999999 | 97.8983 | 167.4879 | 135.6028 | 82.66579999999999 | 31.88509999999997 | 84.82209999999998 | 52.93700000000001 | 129.729 | 154.1154 | 36.41640000000001 | 3.789200000000001 | 176.7749 | 9.286999999999999 | 41.1721 | 94.10910000000001 |  | 7
2011-03-05 00:00:00 | 76.74610000000001 | 92.3546 | 132.017 | 48.60580000000002 | 118.8598 | 86.9701 | 34.0326 | 169.1007 | 151.2369 | 28.1403 | 164.3941 | 163.7162 | 110.7787 | 39.66239999999999 | 140.9604 | 26.5052 | 5.384500000000003 | 58.322 | 179.3772 | 13.1572 | 45.04689999999999 | 97.9844 | 167.4656 | 135.5759 | 82.63840000000002 | 31.8897 | 84.8272 | 52.9375 | 133.2632 | 149.9907 | 40.90859999999998 | 1.2462 | 178.131 | 14.4034 | 46.29309999999998 | 99.23059999999998 |  | 7
2011-03-06 00:00:00 | 77.3364 | 91.3974 | 130.5166 | 50.1651 | 117.2783 | 85.38389999999998 | 32.4461 | 168.7338 | 152.147 | 27.1713 | 165.3853 | 162.7203 | 109.7825 | 39.11919999999998 | 141.5625 | 25.8809 | 6.013500000000022 | 58.9513 | 179.3183 | 13.2383 | 45.1327 | 98.07049999999998 | 167.4434 | 135.549 | 82.6112 | 31.89440000000002 | 84.8322 | 52.93779999999998 | 136.9503 | 145.7133 | 45.55290000000002 | 6.433700000000002 | 172.8846 | 19.672 | 51.56640000000004 | 104.5042 |  | 4
2011-03-07 00:00:00 | 77.92670000000001 | 90.4408 | 129.0168 | 51.72370000000001 | 115.6974 | 83.79830000000001 | 30.86010000000002 | 168.3675 | 153.0565 | 26.203 | 166.3759 | 161.725 | 108.7868 | 38.57600000000002 | 142.1645 | 25.25659999999999 | 6.642499999999984 | 59.58069999999998 | 179.2595 | 13.3194 | 45.21850000000001 | 98.1567 | 167.4211 | 135.522 | 82.58380000000002 | 31.89909999999998 | 84.83729999999997 | 52.93819999999999 | 140.7891 | 141.2842 | 50.34829999999999 | 11.7723 | 167.4872 | 25.0917 | 56.99079999999998 | 109.929 |  | 6
2011-03-08 00:00:00 | 78.51689999999999 | 89.48490000000001 | 127.5176 | 53.2818 | 114.1171 | 82.21329999999998 | 29.2748 | 168.0018 | 153.9655 | 25.23509999999999 | 167.366 | 160.7302 | 107.7917 | 38.03269999999998 | 142.7667 | 24.63219999999995 | 7.271600000000035 | 60.21010000000001 | 179.2006 | 13.4005 | 45.30430000000001 | 98.24279999999999 | 167.3989 | 135.4951 | 82.5566 | 31.90379999999999 | 84.84229999999997 | 52.93849999999998 | 144.7762 | 136.7069 | 55.29129999999998 | 17.2586 | 161.942 | 30.6591 | 62.56290000000001 | 115.5014 |  | 14
2011-03-09 00:00:00 | 79.1071 | 88.52959999999999 | 126.0189 | 54.83920000000001 | 112.5375 | 80.62890000000002 | 27.69000000000003 | 167.6367 | 154.874 | 24.2679 | 168.3554 | 159.736 | 106.7971 | 37.48930000000001 | 143.3688 | 24.00790000000001 | 7.900699999999972 | 60.83959999999996 | 179.1419 | 13.4814 | 45.38999999999999 | 98.32889999999998 | 167.3767 | 135.4681 | 82.52920000000003 | 31.90859999999998 | 84.84749999999997 | 52.93889999999999 | 148.9059 | 131.987 | 60.37630000000001 | 22.887 | 156.2549 | 36.36839999999999 | 68.27699999999999 | 121.2159 |  | 5
2011-03-10 00:00:00 | 79.69729999999998 | 87.57469999999998 | 124.5208 | 56.39609999999999 | 110.9583 | 79.04510000000002 | 26.10580000000002 | 167.272 | 155.7819 | 23.30119999999999 | 169.3444 | 158.7424 | 105.8031 | 36.9461 | 143.9708 | 23.3836 | 8.52959999999996 | 61.46889999999996 | 179.0831 | 13.5625 | 45.47569999999996 | 98.41499999999996 | 167.3544 | 135.4412 | 82.5019 | 31.91319999999996 | 84.85249999999996 | 52.9393 | 153.1696 | 127.1331 | 65.59490000000005 | 28.6488 | 150.4343 | 42.21129999999999 | 74.12450000000001 | 127.0638 |  | 11
2011-03-11 00:00:00 | 80.2875 | 86.62049999999999 | 123.0233 | 57.95240000000001 | 109.3798 | 77.46179999999998 | 24.5222 | 166.908 | 156.6892 | 22.33509999999998 | 170.3327 | 157.7493 | 104.8097 | 36.40280000000001 | 144.5729 | 22.7593 | 9.15870000000001 | 62.09829999999999 | 179.0243 | 13.6435 | 45.56150000000002 | 98.50110000000001 | 167.3322 | 135.4142 | 82.47460000000001 | 31.91800000000001 | 84.85759999999999 | 52.93959999999998 | 157.5563 | 122.1562 | 70.93579999999997 | 34.533 | 144.4913 | 48.1765 | 80.09450000000004 | 133.0341 |  | 7
2011-03-12 00:00:00 | 80.8777 | 85.66690000000003 | 121.5265 | 59.50819999999999 | 107.8018 | 75.8792 | 22.93910000000002 | 166.5446 | 157.5958 | 21.36950000000002 | 171.3205 | 156.7569 | 103.8168 | 35.8596 | 145.1751 | 22.13489999999996 | 9.78770000000003 | 62.7278 | 178.9653 | 13.7247 | 45.64730000000003 | 98.5874 | 167.31 | 135.3874 | 82.44730000000001 | 31.92259999999999 | 84.86269999999996 | 52.94009999999997 | 162.0515 | 117.0708 | 76.38459999999998 | 40.525 | 138.4403 | 54.2497 | 86.1723 | 139.1124 |  | 11
2011-03-13 00:00:00 | 81.46809999999999 | 84.71370000000002 | 120.0301 | 61.0634 | 106.2244 | 74.29700000000003 | 21.35660000000001 | 166.1818 | 158.5018 | 20.40469999999999 | 172.3075 | 155.7651 | 102.8247 | 35.31639999999999 | 145.7771 | 21.51069999999999 | 10.41669999999999 | 63.3571 | 178.9065 | 13.8057 | 45.73309999999998 | 98.67349999999999 | 167.2878 | 135.3604 | 82.42000000000002 | 31.92739999999998 | 84.86779999999999 | 52.94040000000001 | 166.638 | 111.8939 | 81.92430000000002 | 46.6079 | 132.2986 | 60.4136 | 92.34100000000001 | 145.2814 |  | 6
2011-03-14 00:00:00 | 82.05850000000001 | 83.76090000000002 | 118.5342 | 62.6181 | 104.6475 | 72.71540000000002 | 19.77459999999999 | 165.8194 | 159.4073 | 19.44040000000001 | 173.294 | 154.7739 | 101.8331 | 34.77329999999995 | 146.379 | 20.88659999999999 | 11.0455 | 63.98630000000003 | 178.8477 | 13.8867 | 45.81879999999995 | 98.75959999999998 | 167.2656 | 135.3335 | 82.39269999999999 | 31.93209999999999 | 84.87290000000002 | 52.94080000000002 | 171.2959 | 106.6456 | 87.53499999999997 | 52.76169999999999 | 126.086 | 66.6484 | 98.58049999999997 | 151.5213 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tot Crosses | 106
OK - here is my thinking on this puppy!!
This is like first year algebra where you had to graph lines using 2 points
Your dates are your X coordinates and the Series are your Y coordinates
Change the points in B40 to E41 to test the function that is in F41
The function is called LineCrosses and needs two array arguments.
Both Arrays need to be the same size.  Look at formula in F41 for example
Then look at Column AM for answers |  |  |  |  |  |  |  |  |  | Graph of Test Area.
This function will work for any number of series.
Test Area Below
X | y1 | y2 | y3 | y4
x1 | 5 | 8 | 5 | 6
x2 | 3 | 5 | 9 | 6 | 4