Spreadsheet: 866963d1713874748-average-ifs-within-a-targeted-range-more-example
Sheet: Sheet1

 | 2023 |  |  |  |  | 2022 |  |  |  |  | 2023 chg |  |  |  |  | Latest Annual Guidance (Midpoints) |  |  |  |  |  | Latest Annual Guidance (Midpoints)
name | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS |  | Revenue | OI | Adj. EBITDA | Adj. NI | EPS |  | Revenue | Adj. EBITDA | EPS
1 | 957.672 | 167.958 | 201.321 | 9.92 |  | 904.739 | 154.428 | 189.128 | 9.24 |  |  |  |  |  |  | 1052.5 |  |  |  | 9.9
2 | 800.9 | -14.8 | 180.7 | 0.34 |  | 717.8 | -82.6 | -123.3 | 0.37 |  |  |  |  |  |  | 848.9540000000001 |  | 198 |  | 0.395
 | 3433.763 | 122.276 | 193.236 | 1.27 |  | 2613.399 | 106.038 | 157.863 | 1.54 |  |  |  |  |  |  | 3700 |  | 211.5
 | 794.045 | 56.301 | 89.192 | 0.63 |  | 546.259 | 15.138 | 50.384 | 0.28 |  |  |  |  |  |  | 860 |  | 95
 | 1707.197 | 5.452 | 269.2 | 2.4 |  | 1563.101 | -11.178 | 236.1 | 2.27 |  |  |  |  |  |  | 2100 |  | 372.5 |  | 2.575
 | 1264.542 | 99.802 | 294.603 | 0.94 |  | 1085.089 | 102.202 | 245.235 | 1.1 |  |  |  |  |  |  | 1495 |  | 355
 | 798.71 | -38.189 | 148.105 | 0.8 |  | 683.191 | -64.335 | 89.864 | 0.38 |  |  |  |  |  |  | 900 | 156 |  | 133 | 1.065
 | 249.463 | -4.117 | 42.873 | 1.11 |  | 219.164 | -12.955 | 32.09 | 0.72 |  |  |  |  |  |  | 262 |  | 49.5 | 48.4 | 1.285
 | 2619.468 | 329.153 | 578.01 | 1.58 |  | 2412.522 | 258.677 | 520.082 | 1.27 |  |  |  |  |  |  |  |  | 980
 | 354.337 | 38.869 | 123.108 | 0.43 |  | 335.644 | 36.851 | 120.174 | 0.46 |  |  |  |  |  |  | 392.5 |  |  |  | 0.435
 | 2195.63 | 288.139 | 267.5762848173076 | 1.417194807692308 |  | 1494.63 | 236.019 | 231.0209427846154 | 1.221424892307692 |  |  |  |  |  |  | 2330
 | 1147.909 | 172.705 | 265.096 | 4.06 |  | 1034.887 | 181.368 | 253.529 |  |  |  |  |  |  |  | 1295 |  | 275 |  | 3.8
 | 817.31 | 224.312 | 371.502 | 1.08 |  | 741.598 | 170.689 | 338.54 | 1.02 |  |  |  |  |  |  | 872.5 |  | 400 |  | 1.175
 | 703.592 | 118.049 | 146.159 | 3.14 |  | 565.568 | 87.295 | 113.536 | 2.26
 | 881.682 | 76.493 | 153.967 | 2.07 |  | 842.559 | 63.536 | 146.848 | 1.95 |  |  |  |  |  |  | 923 |  | 162 | 117.05 | 2.12
 | 264.831 | -63.442 | -1.58 | -0.041401 |  | 204.27 | -70.218 | -17.551 | -0.234013 |  |  |  |  |  |  | 330 |  | 21.5
 | 1880.896 | 108.693 | 225.809 | 2.88 |  | 1762.403 | 88.983 | 210.408 | 2.88
 | 402.996 | 111.435 | 144.509 | 0.67 |  | 372.51 | 96.213 | 127.556 | 0.62 |  |  |  |  |  |  | 403 |  | 147.5 |  | 0.64
 | 3643.905 | 124.879 | 188.193 | 5.4 |  | 3008.542 | 112.529 | 175.75 | 4.799905
 | 612.701 | 2.796 | 129.138 | 1.13 |  | 572.221 | -5.131 | 108.6 | 0.89 |  |  |  |  |  |  | 668 |  | 147 | 117.4
 | 1657.615 | 232.121 | 267.732 | 5.62 |  | 1488.256 | 258.254 | 285.618 | 6.576298 |  |  |  |  |  |  | 1659 | 196
 | 679.905 | 56.93 | 102.282 | 0.32 |  | 587.104 | 41.676 | 84.955 | 0.25
 | 536.91 | 77.248 | 157.63 | 2.85 |  | 450.875 | 71.182 | 132.268 | 2.35 |  |  |  |  |  |  | 617.75 |  | 184 |  | 3.12
 | 370.239 | 12.154 | 100.363 | 1.52 |  | 294.137 | 8.594 | 79.544 | 1.48 |  |  |  |  |  |  | 397.5 |  | 114 |  | 1.69
 | 109.895 | 38.118 | 40.909 | 3.37 |  | 105.149 | 42.668 | 43.248 | 3.56
 | 148.58 | 40.045 |  |  |  | 151.568 | 46.543
 | 2825.286 | 217.909 | 403.9 | 1.630581 |  | 2687.005 | 195.643 |  |  |  |  |  |  |  |  | 2945.365
 | 807.821 | 196.812 | 367.002 | 0.91 |  | 782.519 | 218.261 | 374.082 | 1.24
 | 906.541 | 132.83 | 190.702 | 3.95 |  | 905.062 | 148.195 | 205.805 | 4.28 |  |  |  |  |  |  | 945 |  |  |  | 4.125
 | 914.242 | 33.395 | 195.702 | 1.23 |  | 1655.035 | 108.643 | 186.653 | 1.02
 | 757.904 | 139.326 | 174.067 | 6.2 |  | 626.435 | 101.125569620253 | 133.323 | 4.39
 | 261.276 | 36.584 | 69.817 | 1.33 |  | 209.39 | 10.128 | 36.654 | 0.55 |  |  |  |  |  |  | 315
 | 128.349 | 19.05 | 31.2 | 0.51 |  | 125.591 | 24.829 | 36.8 | 0.54
 | 1820.6 | 262.1 | 451 | -2.66 |  | 1772.1 | 290.9 | 472.4 | 0.41
 | 219.08 | 4.462 | 73.5 | 8.33 |  | 184.335 | 5.946 | 47.189 | 0.534913
 | 7842.1 | 990.9 | 769.4 | 11.413404 |  | 7826 | 910.5 | 1071.6 | 12.28 |  |  |  |  |  |  | 6840 | 632.5 | 822.5 |  | 10.71
 | 400.072 | 57.809 | 77.267 | 6.19 |  | 353.792 | 34.627 | 59.639 | 5.45
 | 663.102 | 14.045 | 98.283 | 0.73 |  | 747.937 | 70.351 | 142.743 | 1.25
 | 1224.449 | 373.001 |  | 12.5 |  | 838.804 | 254.103 |  | 7.8
 | 1245.62 | 56.56 | 250.913 | 2.12 |  | 1239.784 | 14.163 | 220.1 | 1.86
 | 55068 | 3755 | 2491 | 6.49 |  | 57545 | 3071 | 2335 | 0.73
 | 772.843 | 67.589 | 100.0881302146154 | 1.215516276923077 |  | 735.451 | 64.619 | 104.0413308084615 | 1.453112688461538
 | 92.717 | -6.044 | 14.349 | -0.61 |  | 81.003 | -1.306 | 15.935 | -0.22 |  |  |  |  |  |  | 105 |  | 17.077
 | 408.315 | -91.737 | 32.511 | -0.07 |  | 273.865 | -61.351 | -4.189 | -0.2 |  |  |  |  |  |  | 541.5 | 85 |  |  | 0.62
 | 280.91 | -176.552 | -92.473 | -3.36 |  | 213.233 | -116.817 | -59.023 | -2.37 |  |  |  |  |  |  | 429 |  | 16
 | 2242.9 | 67.5 | 102.6 | 0.05 |  | 2684.8 | 164 | 212.2 | 1.41 |  |  |  |  |  |  | 1725 |  |  | 61 | 0.75
 | 1204.7 | 88.8 | 200.8 | 0.5 |  | 1244.1 | 64.3 | 187.1 | 0.57 |  |  |  |  |  |  |  |  | 212.5
 | 233.255 | -60.932 | -8.304 | -2.21 |  | 237.277 | -34.554 | 13.695 | -0.93 |  |  |  |  |  |  | 247
 | 1218.555 | 94.628 | 250.204 | 1.12 |  | 980.72 | 62.826 | 196.49 | 1.03
 |  |  |  | LY For consensus
AVERAGE |  |  |  |  |  |  |  |  |  |  |  | 0.08064482174830517 | 0.1045955242952886 | 0.05821232690718636 |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]!
MEDIAN
YoY Change
AVERAGE
MEDIAN