Spreadsheet: 831693d1685828004-formula-for-counting-values-across-two-tables-sheets-with-matching-dates-excel-forum-2
Sheet: Tabell1 (5)

 |  |  |  |  |  | PD_Order | #
 |  |  |  |  |  | LH
 |  |  |  |  |  | HL
 |  |  |  |  |  | Sum
Date | Day | O | H | L | C | PD_Order | Order | Variable 1
2023-05-24 00:00:00 | Wednesday | 4140 | 4143.75 | 4114 | 4126.75 |  | LH | 3
2023-02-01 00:00:00 | Wednesday | 4077.75 | 4163.25 | 4048.5 | 4134.5 |  | LH | 3
2023-01-04 00:00:00 | Wednesday | 3869 | 3896.25 | 3836.5 | 3873.75 |  | LH | 3
2022-12-07 00:00:00 | Wednesday | 3933.75 | 3961.5 | 3924.25 | 3936.25 |  | LH | 3
2022-11-23 00:00:00 | Wednesday | 4005.75 | 4039.5 | 4003.25 | 4034.5 |  | LH | 3
2022-10-05 00:00:00 | Wednesday | 3759 | 3820 | 3734 | 3797 |  | LH | 3
2022-08-24 00:00:00 | Wednesday | 4128.5 | 4158.5 | 4121.25 | 4143.75 |  | LH | 3
2022-08-17 00:00:00 | Wednesday | 4269.25 | 4305.25 | 4255 | 4276.5 |  | LH | 3
2022-08-03 00:00:00 | Wednesday | 4115.75 | 4170 | 4112.5 | 4157 |  | LH | 3
2022-07-20 00:00:00 | Wednesday | 3938.5 | 3977.25 | 3924.75 | 3962.5 |  | LH | 3
2022-07-06 00:00:00 | Wednesday | 3836.75 | 3875 | 3811.5 | 3849.5 |  | LH | 3
2022-06-15 00:00:00 | Wednesday | 3776.25 | 3843 | 3723.5 | 3795.5 |  | LH | 3
2022-05-25 00:00:00 | Wednesday | 3925 | 3997.75 | 3921.5 | 3979 |  | LH | 3
2022-05-04 00:00:00 | Wednesday | 4176.5 | 4303 | 4142.75 | 4296.75 |  | LH | 3
2022-04-27 00:00:00 | Wednesday | 4179.25 | 4236.25 | 4157 | 4179.5 |  | LH | 3
2022-04-13 00:00:00 | Wednesday | 4389.25 | 4449.5 | 4387 | 4442.5 |  | LH | 3
2022-04-06 00:00:00 | Wednesday | 4477.75 | 4499.5 | 4444.5 | 4475.5 |  | LH | 3
2022-03-16 00:00:00 | Wednesday | 4294 | 4351.75 | 4242.25 | 4350.75 |  | LH | 3
2022-03-09 00:00:00 | Wednesday | 4254.75 | 4298.25 | 4230.75 | 4277.25 |  | LH | 3
2022-03-02 00:00:00 | Wednesday | 4327.25 | 4399.25 | 4318.75 | 4381.5 |  | LH | 3
2022-02-09 00:00:00 | Wednesday | 4556.75 | 4582.5 | 4554.5 | 4579.5 |  | LH | 3
2021-12-22 00:00:00 | Wednesday | 4637.5 | 4687.5 | 4635.5 | 4686.25 |  | LH | 3
2021-12-08 00:00:00 | Wednesday | 4690.25 | 4703.25 | 4671.75 | 4698.5 |  | LH | 3
2021-11-24 00:00:00 | Wednesday | 4665 | 4700.75 | 4656.25 | 4698.5 |  | LH | 3
2021-11-17 00:00:00 | Wednesday | 4694.75 | 4696.75 | 4679.25 | 4686.25 |  | LH | 3
2021-10-20 00:00:00 | Wednesday | 4515.75 | 4532.25 | 4514.5 | 4529.25 |  | LH | 3
2021-10-13 00:00:00 | Wednesday | 4351 | 4364.75 | 4318.75 | 4355.25 |  | LH | 3
2021-09-22 00:00:00 | Wednesday | 4366.5 | 4406.5 | 4356.5 | 4384.25 |  | LH | 3
2021-09-15 00:00:00 | Wednesday | 4439.5 | 4477.75 | 4427.5 | 4472.25 |  | LH | 3
2021-07-28 00:00:00 | Wednesday | 4401.25 | 4407.75 | 4377.5 | 4392.75 |  | LH | 3
2021-07-21 00:00:00 | Wednesday | 4328 | 4352.25 | 4326 | 4351.25 |  | LH | 3
2021-07-07 00:00:00 | Wednesday | 4342.25 | 4353.25 | 4320.25 | 4349.75 |  | LH | 3
2021-06-30 00:00:00 | Wednesday | 4277.5 | 4293.75 | 4277.25 | 4286.5 |  | LH | 3
2021-05-26 00:00:00 | Wednesday | 4191.5 | 4199 | 4180.5 | 4193.75 |  | LH | 3
2021-05-19 00:00:00 | Wednesday | 4071.75 | 4113 | 4055.5 | 4111.5 |  | LH | 3
2021-05-05 00:00:00 | Wednesday | 4177.75 | 4180 | 4153 | 4161 |  | LH | 3
2021-04-28 00:00:00 | Wednesday | 4182 | 4193.75 | 4172.75 | 4178 |  | LH | 3
2021-03-17 00:00:00 | Wednesday | 3937.5 | 3973.5 | 3925 | 3964 |  | LH | 3
2021-03-10 00:00:00 | Wednesday | 3899 | 3916.25 | 3883.5 | 3897.25 |  | LH | 3
2021-02-17 00:00:00 | Wednesday | 3907.5 | 3930 | 3896.5 | 3928 |  | LH | 3
2021-02-03 00:00:00 | Wednesday | 3827.25 | 3840 | 3807.75 | 3822 |  | LH | 3
2021-01-13 00:00:00 | Wednesday | 3791.25 | 3813.5 | 3782.75 | 3802.5 |  | LH | 3
2020-12-16 00:00:00 | Wednesday | 3691 | 3704.5 | 3681.25 | 3694.75 |  | LH | 3
2020-11-04 00:00:00 | Wednesday | 3409 | 3480 | 3395.75 | 3435 |  | LH | 3
2020-10-07 00:00:00 | Wednesday | 3381.25 | 3416.75 | 3381 | 3407 |  | LH | 3
2020-09-02 00:00:00 | Wednesday | 3546.25 | 3587 | 3533.75 | 3576.5 |  | LH | 3
2020-08-26 00:00:00 | Wednesday | 3446.75 | 3478 | 3441 | 3475 |  | LH | 3
2020-08-12 00:00:00 | Wednesday | 3353.75 | 3382.5 | 3353.5 | 3373.25 |  | LH | 3
2020-07-29 00:00:00 | Wednesday | 3220.5 | 3257 | 3220 | 3250.25 |  | LH | 3
2020-07-01 00:00:00 | Wednesday | 3094.5 | 3117.75 | 3089.25 | 3104.75 |  | LH | 3
2020-06-10 00:00:00 | Wednesday | 3211.75 | 3221.25 | 3179.75 | 3188 |  | LH | 3
2020-05-20 00:00:00 | Wednesday | 2954.5 | 2975.75 | 2952.25 | 2966.25 |  | LH | 3
2020-04-29 00:00:00 | Wednesday | 2913.25 | 2947.25 | 2902.25 | 2929.75 |  | LH | 3
2020-04-22 00:00:00 | Wednesday | 2780.75 | 2808 | 2766.25 | 2789 |  | LH | 3
2020-04-15 00:00:00 | Wednesday | 2772.75 | 2792.75 | 2751.25 | 2775 |  | LH | 3
2020-03-25 00:00:00 | Wednesday | 2444 | 2560.75 | 2393.5 | 2466.5 |  | LH | 3
2020-01-29 00:00:00 | Wednesday | 3290.25 | 3292.75 | 3270.25 | 3272.5 |  | LH | 3
2019-12-18 00:00:00 | Wednesday | 3200 | 3203 | 3195.5 | 3196.75 |  | LH | 3
2019-12-11 00:00:00 | Wednesday | 3137.75 | 3144.5 | 3133.5 | 3141.75 |  | LH | 3
2019-11-13 00:00:00 | Wednesday | 3080.5 | 3097 | 3078 | 3092.5 |  | LH | 3
2019-10-23 00:00:00 | Wednesday | 2992 | 3004.5 | 2989.75 | 3003.5 |  | LH | 3
2019-10-16 00:00:00 | Wednesday | 2989.5 | 2997.5 | 2984.75 | 2990.5 |  | LH | 3
2019-10-09 00:00:00 | Wednesday | 2913.75 | 2929.5 | 2906.5 | 2918.5 |  | LH | 3
2019-09-18 00:00:00 | Wednesday | 3003.5 | 3010.75 | 2980.75 | 3009.5 |  | LH | 3
2019-09-04 00:00:00 | Wednesday | 2930 | 2939 | 2921.5 | 2938.25 |  | LH | 3
2019-07-24 00:00:00 | Wednesday | 2999.5 | 3022 | 2998.75 | 3021.5 |  | LH | 3
2019-06-19 00:00:00 | Wednesday | 2925.5 | 2936.75 | 2915.25 | 2931 |  | LH | 3
2019-03-20 00:00:00 | Wednesday | 2836.5 | 2849.25 | 2817.25 | 2829.5 |  | LH | 3
2019-03-13 00:00:00 | Wednesday | 2807.5 | 2826.5 | 2805.5 | 2816.25 |  | LH | 3
2019-01-16 00:00:00 | Wednesday | 2614.75 | 2626.25 | 2612.5 | 2616.5 |  | LH | 3
2019-01-09 00:00:00 | Wednesday | 2583 | 2596.75 | 2569 | 2586.25 |  | LH | 3
2018-10-17 00:00:00 | Wednesday | 2812.25 | 2819.25 | 2783.25 | 2812.25 |  | LH | 3
2018-09-19 00:00:00 | Wednesday | 2911.5 | 2918.75 | 2910 | 2914.25 |  | LH | 3
2018-09-12 00:00:00 | Wednesday | 2888 | 2895.25 | 2879.5 | 2888.75 |  | LH | 3
2018-08-22 00:00:00 | Wednesday | 2859.5 | 2868.25 | 2856.25 | 2862.75 |  | LH | 3
2018-08-08 00:00:00 | Wednesday | 2857 | 2862.5 | 2853 | 2857.75 |  | LH | 3
2018-06-20 00:00:00 | Wednesday | 2774 | 2778.25 | 2767 | 2771 |  | LH | 3
2018-05-23 00:00:00 | Wednesday | 2710.5 | 2732.75 | 2708.5 | 2732.75 |  | LH | 3
2018-05-09 00:00:00 | Wednesday | 2677.25 | 2700 | 2672 | 2696.25 |  | LH | 3
2018-04-18 00:00:00 | Wednesday | 2711.75 | 2718 | 2703.75 | 2708.75 |  | LH | 3
2018-03-28 00:00:00 | Wednesday | 2614.75 | 2633.75 | 2593 | 2605 |  | LH | 3
2018-03-07 00:00:00 | Wednesday | 2702.5 | 2730.25 | 2700.25 | 2726 |  | LH | 3
2018-01-10 00:00:00 | Wednesday | 2744 | 2751.75 | 2736.5 | 2748.75 |  | LH | 3
2017-11-15 00:00:00 | Wednesday | 2566.25 | 2571.5 | 2555.5 | 2563.75 |  | LH | 3
2017-09-27 00:00:00 | Wednesday | 2503.5 | 2509.25 | 2493 | 2504.5 |  | LH | 3
2017-08-23 00:00:00 | Wednesday | 2440.5 | 2447.75 | 2438.75 | 2442.75 |  | LH | 3
2017-08-09 00:00:00 | Wednesday | 2463.5 | 2472 | 2459.25 | 2471 |  | LH | 3
2017-07-12 00:00:00 | Wednesday | 2435 | 2443.75 | 2434.75 | 2441.25 |  | LH | 3
2017-07-05 00:00:00 | Wednesday | 2428.5 | 2432.25 | 2419.25 | 2429.5 |  | LH | 3
2017-03-29 00:00:00 | Wednesday | 2352 | 2359.75 | 2348.75 | 2357.5 |  | LH | 3
2017-03-22 00:00:00 | Wednesday | 2340.25 | 2348.75 | 2332.75 | 2345.25 |  | LH | 3
2017-02-15 00:00:00 | Wednesday | 2332.75 | 2349.75 | 2332 | 2346.75 |  | LH | 3
2017-01-25 00:00:00 | Wednesday | 2286.5 | 2295.25 | 2284.25 | 2294.5 |  | LH | 3
2017-01-04 00:00:00 | Wednesday | 2256.25 | 2267.25 | 2256 | 2264.75 |  | LH | 3
2016-11-09 00:00:00 | Wednesday | 2118.75 | 2166.75 | 2118.25 | 2159.75 |  | LH | 3
2016-10-26 00:00:00 | Wednesday | 2127.5 | 2140 | 2124.75 | 2133.25 |  | LH | 3
2016-10-05 00:00:00 | Wednesday | 2150.5 | 2158 | 2149.75 | 2153 |  | LH | 3
2016-07-06 00:00:00 | Wednesday | 2073.75 | 2093.75 | 2065.75 | 2093 |  | LH | 3
2016-06-08 00:00:00 | Wednesday | 2112.75 | 2119.75 | 2111.25 | 2118 |  | LH | 3
2016-06-01 00:00:00 | Wednesday | 2085.75 | 2099.25 | 2083.25 | 2097 |  | LH | 3
2016-05-25 00:00:00 | Wednesday | 2081.5 | 2092.5 | 2080.75 | 2086.75 |  | LH | 3
2016-04-20 00:00:00 | Wednesday | 2095.5 | 2105.25 | 2089.5 | 2096.5 |  | LH | 3
2016-04-13 00:00:00 | Wednesday | 2065.75 | 2077 | 2064 | 2076 |  | LH | 3
2016-04-06 00:00:00 | Wednesday | 2038.25 | 2060.5 | 2035 | 2059.75 |  | LH | 3
2016-03-16 00:00:00 | Wednesday | 2000.25 | 2022.75 | 1999.75 | 2018.5 |  | LH | 3
2016-03-09 00:00:00 | Wednesday | 1987.5 | 1991.75 | 1978 | 1988 |  | LH | 3
2016-02-17 00:00:00 | Wednesday | 1906 | 1927.25 | 1904 | 1923 |  | LH | 3
2016-01-20 00:00:00 | Wednesday | 1844.75 | 1869.25 | 1804.25 | 1851.75 |  | LH | 3