Spreadsheet: 706953d1606977682-excel-median-if-array-formula-book4
Sheet: Sheet1

 |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  | Grand Total
Row Labels | Format | site_id | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
Existing Store | 4-star | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 926.28 | 2360.4 | 1086.19 | 4372.87
Existing Store | 4-star | 2 |  |  |  |  |  |  |  |  |  |  | 2148.68 | 1567.06 | 2489.23 | 1256.43 | 1232.11 |  |  | 2867.83 | 2065.45 | 945.57 | 1569.01 | 2089.98 | 18231.35
Existing Store | 4-star | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1039.73 |  |  | 4387.65 | 2799.64 | 346.4 | 210.21 | 2402.67 | 11186.3
Existing Store | 4-star | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 369.72 |  |  | 2629.06 | 1281.73 | 1059.1 | 1612.44 | 1401.77 | 8353.82
Existing Store | 4-star | 5 |  |  |  |  |  |  |  |  |  |  |  | 1910.65 | 1772.24 | 1293.99 | 324.09 |  | 1290.63 | 2166.06 | 4016.27 | 865.72 | 1850.42 | 1772.78 | 17262.85
Existing Store | 4-star | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2525.28 | 2051.27 | 4576.55
Existing Store | 4-star | 7 | 1524.71 | 1181.23 | 436.7 | 3378.51 | 1042.83 | 1206.41 | 2230.38 | 2007.74 | 2698.92 | 7621.66 | 2795.83 | 1040.42 | 2574.59 | 887.68 | 208.86 |  |  | 1378.64 | 809.6 | 3439.96 | 1923.02 | 646.91 | 39034.6
Existing Store | 4-star | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2478.86 | 1465.1 | 2365.96 | 2499.68 | 2130.91 | 10940.51
Existing Store | 4-star | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2053.15 | 2053.15
Existing Store | 4-star | 10 | 1618.84 | 1327.63 | 287.55 | 4730.55 | 2597.78 | 1694.41 | 5112.01 | 1892.55 | 1853.46 | 6760.17 | 1618.64 | 1055.25 | 3448.46 | 613.24 | 2028.94 |  |  | 5696.61 | 8217.27 | 1254.63 | 2371.89 | 2174.45 | 56354.33
Existing Store | 4-star | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 2421.41 | 3907.71 | 909.79 |  |  | 2098.46 | 3483.45 | 1578.93 | 2514.95 | 2962.17 | 19876.87
Existing Store | 4-star | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1279.84 | 1279.84
Existing Store | 4-star | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1739.64 | 1739.64
Existing Store | 4-star | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 655.8 | 2406.95 | 1326.5 | 4389.25
Existing Store | 4-star | 15 | 1575.89 | 1961.19 | 930.88 | 5983.75 | 2489.21 | 1879 | 5448.92 | 3226.16 | 1367.62 | 6912.55 | 3906.64 | 1739.5 | 1496.2 | 5245.39 | 935.83 |  |  |  | 2075.5 | 701 | 1358.6 | 1565.75 | 50799.58
Existing Store | 4-star | 16 |  |  |  |  |  |  |  |  |  |  |  | 1064.83 | 2207.43 | 97.69 | 303.96 |  |  | 1899.25 | 1498.3 | 358.18 | 1835.64 | 1758.83 | 11024.11
Existing Store | 4-star | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1463.45 | 1767.78 | 3231.23
Existing Store | 4-star | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275.84 | 299.29 | 419.03 | 994.16
Existing Store | 4-star | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3409.7 | 1463.32 | 4873.02
Existing Store | 4-star | 20 |  |  |  |  |  |  |  |  | 3330.49 | 10317.25 | 9257.27999999999 | 1585.2 | 1917.11 | 2170.88 | 493.73 |  |  | 4389.5 | 5302.41 | 2627.82 | 2897.65 | 3091.37 | 47380.69
Existing Store | 4-star | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3647.21 | 2297.64 | 5944.85
Existing Store | 4-star | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 2136.44 | 883.35 | 994.37 |  |  | 4705.71 | 2284.23 | 1782.5 | 2599.21 | 2501.15 | 17886.96
Existing Store | 4-star | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 304.29 | 2831.2 | 3135.49
Existing Store | 4-star | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 784.05 | 2912.62 | 3696.67
Existing Store | 4-star | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3088.37 | 3088.37
Existing Store | Books | 26 | 878.03 | 359.64 | 8.2 | 277.74 | 796.38 | 390.37 | 1108.96 | 116.94 | 3133.63 | 1739.04 | 1287.19 | 1109.33 | 1463.73 | 324.8 | 276.99 |  | 194.25 | 2343.71 | 1171.64 | 348.14 | 1055.35 | 286.86 | 18670.92
Existing Store | Books | 27 |  |  |  |  |  |  |  |  |  |  |  | 1366.19 | 2173.76 | 1127.61 | 516.69 |  |  | 1796.62 | 777.76 | 663.93 | 1964.43 | 1481.42 | 11868.41
Existing Store | Books | 28 | 570.23 | 173.01 | 984.49 | 461.06 | 471.72 | 556.81 | 2249.19 | 638.73 | 2607.05 | 4754.66 | 1173.69 | 1068.22 | 1148.41 | 204.69 | 274.38 |  |  | 706.8 | 1143.11 | 482.51 | 890.61 | 751.63 | 21311
Existing Store | Books | 29 | 849.46 | 282.64 | 24.9 | 1247.72 | 409.33 | 18.49 | 3065.05 | 298.13 | 169.99 | 896.85 | 3376.43 | 836.65 | 263.99 | 81.15 |  |  |  | 832.78 | 397.39 | 166.37 | 938.28 | 453.4 | 14609
Existing Store | Books | 30 | 1104.33 | 235.12 | 117.82 | 4149.84 | 563.43 | 593.78 | 4774.46 | 1364.47 | 764.55 | 659.7 | 5969.62 | 815 | 1140.3 | 1488.01 | 1136.49 |  |  |  | 4064.72 | 741.3 | 233.73 | 869.42 | 30786.09
Existing Store | Books | 31 | 768.07 | 558.04 | 83.67 | 760.65 | 777.39 | 311.01 | 4848.09 | 295.35 | 75.93 | 1529.3 | 1472.78 | 1182.83 | 424.64 | 203.54 | 111.43 |  |  | 1157.5 | 925.16 | 1247.5 | 1306.33 | 434.27 | 18473.48
Existing Store | Books | 32 |  |  |  | 2934.04 | 1344.6 | 485.73 | 3155.17 | 784.55 | 2010.52 | 5813.04 | 1914.91 | 1045.79 | 1278.69 | 212.43 | 158.34 |  | 2.16 | 1762.93 | 2043.78 | 199.44 | 1114.3 | 654.16 | 26914.58
Existing Store | Books | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1462.19 | 1204.89 | 2667.08
Existing Store | Books | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1345.4 | 1345.4
Existing Store | Books | 35 | 976.23 | 254.76 | 205.9 | 1752.77 | 658.32 | 591.59 | 3591.77 | 475.1 | 608.78 | 9558.52 | 2526.45 | 2594.5 | 1807.74 | 293.38 | 761.59 |  |  |  | 3674.62 | 667.47 | 2091.92 | 1299.03 | 34390.44
Existing Store | Books | 36 | 1146.73 | 397.49 |  | 2030.55 | 1261.67 | 1804.12 | 3401.58 | 446.89 | 604.83 | 1634.68 | 8943.76 | 1323.34 | 1038.06 | 1341.63 | 1274.03 |  |  |  | 4811.54 | 489.71 | 3098.64 | 290.85 | 35340.1
Existing Store | Books | 37 |  |  |  |  |  |  |  |  |  | 4340.34 | 2265.36 | 978.51 | 1894.81 | 1652.42 | 203.29 |  |  | 1366.07 | 915.79 | 403.47 | 2204.06 | 739.71 | 16963.83
Existing Store | Books | 38 | 662.57 | 1324.03 | 514.44 | 2368.4 | 1224.33 | 322.07 | 3262.21 | 2199.25 | 787.27 | 5943.79 | 569.44 | 940.68 | 2026.07 | 945.32 | 99.23 |  |  | 1530.58 | 1382.24 | 830.47 | 2107.51 | 306.5 | 29346.4
Existing Store | Books | 39 | 311.47 | 1782.02 | 62.99 | 2454.7 | 1272.84 | 478.51 | 3038.31 | 306.48 | 555.1 | 3949.49 | 371.23 | 830.4 | 1234.89 | 225.59 | 420.94 |  |  | 2118.52 | 440.54 | 152.27 | 913.56 | 563.63 | 21483.48
Existing Store | Books | 40 | 494.5 | 346.24 | 77.19 | 1582.56 | 1174.73 | 785.38 | 2727.41 | 217.32 | 43.55 | 1001.96 | 1940.86 | 1718.73 | 932.19 | 100.08 | 561.88 |  |  |  | 1595.72 | 392.74 | 646.98 | 1252.26 | 17592.28
Existing Store | Books | 41 | 799.13 | 720.91 | 44.97 | 888.11 | 1245.61 | 2332.92 | 3014.85 | 298.29 | 2473.69 | 5956.34 | 3660.03 | 910.84 | 1494.44 |  | 468.31 |  |  | 1556.84 | 606.95 | 333.2 | 1721.58 | 408.28 | 28935.29
Existing Store | Books | 42 | 788.34 | 603.54 | 20.7 | 1154.24 | 207.67 | 262.97 | 2682.08 | 157.93 | 173.03 | 7065.15 | 1258.01 | 1063.05 | 998.62 | 214.29 | 194.12 |  |  | 2961 | 116.7 | 1001.3 | 1576.12 | 1070.02 | 23568.88
Existing Store | Books | 43 | 689.45 | 793.21 | 95.3 | 2136.05 | 868 | 2841.5 | 2313.87 | 1080.89 | 678.12 | 1918.47 | 4939.4 | 1962.36 | 1540.04 | 1828.71 | 407.65 |  |  | 590.08 | 3566.38 | 1071.93 | 1633.13 | 800.62 | 31755.16
Existing Store | Books | 44 | 189.37 | 231.02 | 30.63 | 174.37 | 14.8 | 395.86 | 907.11 | 30.42 | 282.65 | 938.51 | 2596.07 | 1141.96 | 351.73 | 422.18 | 6.83 | 128.18 |  | 2551.4 | 541.96 | 162.25 | 2017.02 | 169.26 | 13283.58
Existing Store | Books | 45 |  |  |  |  |  |  |  |  |  |  |  | 1459.66 | 1874.93 | 300 | 510.61 |  | 927.48 | 3703.7 | 1391.79 | 399.2 | 1555.62 | 97.89 | 12220.88
Existing Store | Books | 46 | 1052.55 | 477.31 | 1083.6 | 3006.61 | 1685.83 | 897.8 | 7597.69 | 578.38 | 223.62 | 3623.98 | 972.47 | 1528.62 | 934.89 | 173.68 | 2676.05 |  |  | 3814.97 | 1607.07 | 718.27 | 2726.75 | 1481.15 | 36861.29
Existing Store | Books | 47 | 1176.24 | 984.61 | 1671.59 | 2352.26 | 1505.61 | 1392.49 | 3734.28 | 3198.97 | 2573.38 | 5123.45 | 1522.12 | 2159.99 | 550.43 | 586.93 | 58.06 |  |  | 1353.4 | 1467.13 | 865.69 | 1042.84 | 576.2 | 33895.67
Existing Store | Books | 48 | 841.78 | 439.21 | 4.32 | 1457.39 | 523.17 | 120.27 | 2362.38 | 19.2 | 1042.5 | 3708.67 | 788.91 | 2181.47 | 937.61 | 117.07 | 766.08 |  |  | 2284.67 | 605.01 | 374.63 | 1546.34 | 1934.95 | 22055.63
New Store | 4-star | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5320.01 | 6723.58 |  |  |  | 12043.59
New Store | 4-star | 50 |  |  |  |  |  |  |  |  | 8182.76 | 5966.35 |  |  |  |  |  |  |  |  |  |  |  |  | 14149.11
New Store | 4-star | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11217.54 |  |  |  |  |  |  |  |  | 11217.54
New Store | 4-star | 52 |  |  |  |  |  |  |  |  |  |  |  |  | 8039.3 | 2229.61 |  |  |  |  |  |  |  |  | 10268.91
New Store | 4-star | 53 |  |  |  |  |  |  |  |  |  | 14365.47 | 2698.06 |  |  |  |  |  |  |  |  |  |  |  | 17063.53
New Store | 4-star | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9717.77 | 492.99 |  |  | 10210.76
New Store | 4-star | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2180.45 | 8705.02 |  |  |  |  |  |  |  | 10885.47
New Store | 4-star | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 843.87 | 11374.46 |  | 12218.33
New Store | 4-star | 57 |  |  |  |  |  |  |  |  |  |  | 13707.96 | 4130.47 |  |  |  |  |  |  |  |  |  |  | 17838.43
New Store | 4-star | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9605.56 | 3026.14 | 12631.7
New Store | 4-star | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7710.58 |  | 7710.58
New Store | 4-star | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2925.52 | 5256.67 |  | 8182.19
New Store | 4-star | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8757.72 | 3601.18 |  |  |  | 12358.9
New Store | 4-star | 62 |  |  |  |  |  |  |  |  |  |  | 6467.67 |  |  |  |  |  |  |  |  |  |  |  | 6467.67
New Store | 4-star | 63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9098.95 | 355.83 |  |  | 9454.78
New Store | 4-star | 64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4397.05 | 3177.79 |  |  |  | 7574.84
New Store | 4-star | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13168.33 |  |  | 13168.33
New Store | 4-star | 66 |  |  |  |  |  |  |  | 19629.29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19629.29
New Store | 4-star | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8745.88 |  |  | 8745.88
New Store | 4-star | 68 |  |  |  |  |  |  |  |  |  |  |  | 4979.75 |  |  |  |  |  |  |  |  |  |  | 4979.75
New Store | 4-star | 69 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9590.54 | 1239.25 |  |  | 10829.79
New Store | 4-star | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11516.85 |  |  | 11516.85
New Store | 4-star | 71 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8978.62 |  | 8978.62
New Store | 4-star | 72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7759.06 | 7759.06
New Store | Books | 73 |  |  |  |  |  |  |  |  |  |  | 9050.71 |  |  |  |  |  |  |  |  |  |  |  | 9050.71
New Store | Books | 74 |  | 3672.84 | 2513.13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6185.97
New Store | Books | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4483.32 |  |  | 4483.32
New Store | Books | 76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5118.4 |  | 5118.4
New Store | Books | 77 | 365.67 | 639.08 |  |  |  |  |  |  | 9849.36 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10854.11
New Store | Books | 78 |  |  |  |  |  |  |  |  |  |  | 7693.82 |  |  |  |  |  |  |  |  |  |  |  | 7693.82
Grand Total |  |  | 18383.59 | 18744.77 | 9198.97 | 45281.87 | 22135.25 | 19361.49 | 70625.77 | 39263.03 | 46090.8 | 122099.39 | 106894.02 | 47291.25 | 54012.38 | 43827.47 | 28429.14 | 128.18 | 2414.52 | 85603.98 | 110455.76 | 74667.32 | 122334.92 | 78072.29 | 1165316.16
 |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  | Grand Total
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
Existing Store | Books
Existing Store | 4-star
New Store | Books
New Store | 4-star
number of rows matching criteria AND having nonblank values in    → Columns D and right