Spreadsheet: 847053d1698152110-vlookup-and-if-example
Sheet: Sales Summary

 |  | 2022 | 2023 | 2024
Cus_Ref_ | Quality_Code | Sum of Sale_Value | Sum of Sale_Value | Sum of Sale_Value
ABEL1 | 004 | 304.04 | 265.68
ABEL1 | 008 |  | 59.87 | 547.43
ABEL1 | 010 | 1821.89 | 1576.72 | 208.61
ABEL1 | 012 | 15207.99999999999 | 19005.81 | 19231.9
ABEL1 | 014 | 56.48
ABEL1 | 015 |  | 101.12
ABEL1 | 019 |  | 133.09
ABEL1 | 020 |  | 2531.65 | 10305.75
ABEL1 | 024 |  | 13.78 | 247.88
ABEL1 | 027 | 12.32
ABEL1 | 037 | 210.19
ABEL1 | 039 |  | 1640.93 | 0
ABEL1 | 047 |  |  | 420.17
ABEL1 | 048 |  |  | 231.1
ABEL1 | 056 |  | 584.05
ABEL1 | 073 | 26216.60999999999 | 10501.46 | 4185.940000000001
ABEL1 | 074 | 581.96 | 645.6999999999999
ABEL1 | 077 | 276.94
ABEL1 | 078 |  | 203.06
ABEL1 | 079 |  | 101.42 | 17.85
ABEL1 | 082 | 744.8199999999999 | 573.25
ABEL1 | 085 | 51800.82000000001 | 110963.81 | 68032.89000000001
ABEL1 | 087 | 26496.5 | 8623.56 | 9185.140000000001
ABEL1 | 088 | 12582.91 | 10161.44 | 1157.08
ABEL1 | 090 | 31.19 | 198.86 | 120.27
ABEL1 | 095 |  | 157.25
ABEL1 | 1 |  |  | 0
ABEL1 | 111 | 5306.73
ABEL1 | 113 | 939.09 | 3154.3 | 1742.17
ABEL1 | 118 | 166.59 | 25.44 | 89.48
ABEL1 | 119 | 2436.5 | 2534.380000000001 | 105.52
ABEL1 | 120 | 824.97 | 479.73 | 262.32
ABEL1 | 125 | 52655.78999999999 | 39992.87000000002 | 11324.93
ABEL1 | 126 | 90.25
ABEL1 | 137 | 1115.06 | 2146.31
ABEL1 | 149 | 1411.49 | 10072.58 | 2885.56
ABEL1 | 157 |  | 323.59
ABEL1 | 161 |  | 25223.19 | 1628.81
ABEL1 | 162 | 23.26
ABEL1 | 171 | 3129.21 | 310.48
ABEL1 | 173 | 295.95 | 459.96 | 358.45
ABEL1 | 179 | 129.58 | 120.79
ABEL1 | 183 | 406.07
ABEL1 | 189 | 146.31 | 479.26 | 231.94
ABEL1 | 190 | 13797.8 | 26809.07999999999 | 9548.46
ABEL1 | 196 | 49.2
ABEL1 | 197 | 89.03 |  | 242.52
ABEL1 | 198 | 423.86 | 1218.83
ABEL1 | 202 | 118.18
ABEL1 | 206 | 5382.09 | 21392.80000000001 | 9496.08
ABEL1 | 207 |  | 1224.75 | 848.9399999999999
ABEL1 | 219 | 20641.76 | 32315.71000000001 | 21502.04
ABEL1 | 220 | 21242.31 | 6679.33
ABEL1 | 223 | 4486.08 | 7526.52
ABEL1 | 226 | 16027.85 | 10968.37 | 3434.92
ABEL1 | 227 | 3099.949999999999 | 3333.380000000001 | 903.08
ABEL1 | 229 |  |  | 192.47
ABEL1 | 231 | 7860.65 | 11275.84 | 561.32
ABEL1 | 233 | 1419.59 | 1536.24 | 789.09
ABEL1 | 236 | 626.8000000000001 | 2096.57 | 326.49
ABEL1 | 237 | 1987.97 | 784.97 | 676.4
ABEL1 | 238 | 1038.72 | 261.58
ABEL1 | 239 | 546.97 | 220.69 | 269.23
ABEL1 | 240 | 2093.17 | 4565.46 | 284.56
ABEL1 | 243 | 4592.929999999999 | 10035.79 | 3057.31
ABEL1 | 250 |  |  | 68.07
ABEL1 | 251 |  | 96.64
ABEL1 | 253 |  |  | 68.07
ABEL1 | 254 | 1546.49 | 692.4 | 84.6
ABEL1 | 256 | 348.34 | 17.02 | 511.97
ABEL1 | 257 | 574.63 | 59.48 | 34.03
ABEL1 | 258 | 999.6700000000001 | 10358.27 | 4052.39
ABEL1 | 260 |  | 324.42
ABEL1 | 266 |  | 155.94
ABEL1 | 285 | 2116.059999999999 | 1250.04 | 530.03
ABEL1 | 295 | 326.53 | 1007.87
ABEL1 | 298 | 3971.349999999999 | 6495.590000000002 | 5979.58
ABEL1 | 299 | 14890.58 | 22431.4
ABEL1 | 316 | 1056.85 | 569.53 | 385.3100000000001
ABEL1 | 317 | 0
ABEL1 | 321 | 2944.9 | 40339.66 | 7807.08
ABEL1 | 322 | 110.39 | 280.8200000000001 | 791.5
ABEL1 | 323 | 749.59 | 869.7099999999999 | 379.14
ABEL1 | 324 | 1429.48 | 2519.63 | 2006.9
ABEL1 | 330 |  | 79.14
ABEL1 | 335 | 0 | 1294.55
ABEL1 | 336 | 2116.91 | 3101.250000000001 | 2991.73
ABEL1 | 337 |  | 55 | 80.42
ABEL1 | 340 | 59.01 | 16.57
ABEL1 | 358 |  | 1981.6
ABEL1 | 366 | 7.6
ABEL1 | 367 | 1874.59 | 14459.06 | 230.75
ABEL1 | 369 | 50.12 | 1175.69 | 302.52
ABEL1 | 392 |  | 8965.269999999999
ABEL1 | 397 |  |  | 6013.87
ABEL1 | 398 |  |  | 679.16
ABEL1 | 401 | 17472.8 | 17622.73 | 10199.15
ABEL1 | 430 | 14381.76 | 26605.06 | 5254.940000000001
ABEL1 | 433 | 202.75 | 217.24
ABEL1 | 434 | 516.1899999999999 | 182.43
ABEL1 | 436 | 0
ABEL1 | 437 | 0
ABEL1 | 449 |  | 480.65 | 295.44
ABEL1 | 452 |  | -41.37000000000012
ABEL1 | 458 |  |  | 166.39
ABEL1 | 478 |  | 1707.89 | 1804.71
ABEL1 | 479 |  | 25723.35999999999 | 11165.67
ABEL1 | 499 |  | 22.36
ABEL1 | 505 |  |  | 294.18
ABEL1 | 507 |  | 44.7 | 34.28999999999999
ABEL1 | 522 |  |  | 241.14
ABEL1 | 527 |  | 42.94 | 4890.67
ABEL1 | 537 |  |  | 1247.89
ABEL1 | 777 | 173.2
ABEL1 | 903 | 829.0600000000001
ABEL1 | 905 | 39649.47000000002 | 16957.26000000001 | 6085.720000000001
ABEL1 | 906 | 10416.93 | 7446.469999999999 | 3308.4
ABEL1 | 907 | 57.87 | 279.88
ABEL1 | BIN | 0
ABEL1 | PBK | 0
ABEL1 | PCA | 630.24 | 3181.14 | 2105.06