Spreadsheet: 888174d1738625084-sum-product-multiply-column-1-by-column-2-depending-on-column-3s-content-02-03-2025-multiply-column-vs-column-with-condition
Sheet: Sheet1

Business | Inventory Value Unit Conversion | Total Physical Count | Converted Variance |  |  | Condition | Result
HF | 115.9884895639694 | 353 | -173.8242584217754 |  |  | HF
HF | 111.9679904468328 | 405 | -130.8243883861455 |  |  | RYAN
RYAN | 61.23892307692308 | 0 | -130
HF | 91.9204586671751 | 45 | -52.45240754764494
HF | 41.29809836065574 | 207 | -98
HF | 68.31431683427004 | 723.0000000000001 | -34.400533266313
HF | 16.69889482767772 | 2974 | -134.5650000000001
HF | 22.2776 | 0 | -100
HF | 58.31240657698057 | 0 | -33.45
HF | 1.681906698294364 | 0 | -1106.625
HF | 85.23237864559644 | 39 | -19.762996875
HF | 76.88750121206245 | 46 | -18.45625
HF | 43.86967202141901 | 1464 | -30
HF | 2.26 | 3465 | -511
HF | 28.82674071788542 | 452 | -34.14999999999998
HF | 44.04065093057053 | 1687 | -19.48000000000002
HF | 42.29067025934658 | 101 | -17.76000000000001
HF | 117.5548965594783 | 350 | -5.759999999999991
HF | 46.2511174682639 | 9 | -13.372
HF | 38.05743944636678 | 0 | -14.45
HF | 1.108171203673336 | 14785 | -460
HF | 21.37798006068487 | 0 | -23.07
HF | 53.03328852997235 | 1807 | -8.339999999999918
HF | 9.96 | 33 | -44
HF | 43.26743850828538 | 858 | -9.190000000000055
HF | 1.160794858466046 | 20825 | -336
RYAN | 174 | 103 | -2.200000000000003
HF | 19.25899173553719 | 587 | -18
HF | 42.8443173934885 | 1246 | -8.089999999999918
HF | 35.71132083112008 | 4189 | -9.1899999999996
HF | 1.345550084889644 | 5700 | -190
HF | 22.21260583254939 | 0 | -10.63
HF | 19.05944089456869 | 614 | -12
HF | 34.36366257071817 | 1104 | -6.039999999999964
HF | 4.7 | 33 | -44
HF | 45 | 2143 | -4.510000000000218
HF | 19.40907675541024 | 632 | -10.29999999999995
HF | 48.6200101061142 | 115 | -3.739999999999995
HF | 43.5339736639452 | 2606 | -4.110000000000127
HF | 26.82 | 1337 | -6
HF | 45.75975975975976 | 0 | -3.33
HF | 61.80091452690819 | 26 | -2.43
HF | 70.61167002012073 | 8 | -1.94
HF | 21.45306309052118 | 0 | -5.2496
HF | 28.03050847457627 | 0 | -2.95
HF | 0.69 | 11525 | -119
HF | 61.77663934426229 | 28 | -1.280000000000001
HF | 0.06584001534237727 | 494200 | -1160
HF | 34.13726692836114 | 487 | -2.120000000000005
HF | 71.65042780748664 | 186 | -1
HF | 34.95425014148274 | 440 | -1.75
HF | 58.42763948497854 | 232 | -1
RYAN | 41.50912059225255 | 1236 | -1.309999999999945
HF | 31.91082802547771 | 0 | -1.57
HF | 47.94659090909091 | 43 | -1
HF | 44.19 | 6 | -1
HF | 42.57227621483376 | 390 | -1
HF | 19.60057643809295 | 664 | -2.159999999999968
HF | 42.17633663366337 | 201 | -1
HF | 50.15886352062596 | 82 | -0.7203750000000042
HF | 19.90997074049066 | 176 | -1.719999999999999
HF | 2.700001214397902 | 4930 | -10.72000000000025
HF | 39.99719416386083 | 0 | -0.7128
RYAN | 22.51 | 0 | -1
HF | 3.6 | 0 | -6
RYAN | 37.90378772802654 | 1507 | -0.5
HF | 37.2972972972973 | 0 | -0.37
RYAN | 6.880231077147016 | 42 | -1.968000000000004
HF | 24.62264150943396 | 0 | -0.53
HF | 47.02262068965517 | 36 | -0.25
HF | 22.79591836734694 | 0 | -0.49
HF | 19.39606167564555 | 807 | -0.4500000000000455
HF | 19.79744289081687 | 810 | -0.2899999999999636
HF | 50.3 | 0 | -0.1
RYAN | 25.9538053533983 | 2432 | -0.09999999999990905
HF | 32.79844738552033 | 1462 | -0.04999999999995453
HF | 1.569139376158295 | 17860.19 | -0.1100000000005821
HF | 0 | 0 | 0
HF | 37.75973684210526 | 38 | 0
HF | 46.75989285714286 | 280 | 0
HF | 39.85923076923077 | 130 | 0
HF | 44.21079012345679 | 405 | 0
HF | 42.73073684210527 | 570 | 0
HF | 38.86133333333333 | 15 | 0
RYAN | 20.87 | 2 | 0
HF | 40.54522222222222 | 90 | 0
HF | 43.33579310344827 | 145 | 0
HF | 58.13190476190476 | 105 | 0
HF | 42.48907608695652 | 184 | 0
HF | 37.70769230769231 | 65 | 0
HF | 40.6088 | 150 | 0
HF | 49.82604166666667 | 48 | 0
HF | 41.8556 | 250 | 0
HF | 43.8 | 1 | 0
HF | 50.86422018348624 | 109 | 0
HF | 39.91745454545455 | 55 | 0
HF | 45.348 | 20 | 0
RYAN | 51.24673214285714 | 560 | 0
RYAN | 53.951 | 290 | 0
RYAN | 50.97580487804878 | 205 | 0
RYAN | 55.54721428571428 | 280 | 0
RYAN | 43.0002380952381 | 84 | 0
RYAN | 42.69 | 1 | 0
RYAN | 48.24275 | 280 | 0
HF | 0.9164102564102564 | 4875 | 0
HF | 1.448820835718374 | 3494 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 17.09461538461538 | 52 | 0
HF | 21.65 | 4 | 0
HF | 33.91 | 4 | 0
HF | 21.13666666666667 | 30 | 0
HF | 1.370001193435069 | 1927.21 | 0
HF | 0 | 52 | 0
HF | 0 | 0 | 0
HF | 188.3221739130435 | 46 | 0
HF | 199.3272727272727 | 11 | 0
HF | 176.3923809523809 | 21 | 0
HF | 46.0344 | 1025 | 0
HF | 42.33558139534884 | 43 | 0
HF | 41.55315384615385 | 130 | 0
HF | 43.6756279468172 | 53.0021 | 0
HF | 0 | 0 | -9990609120
HF | 124.8 | 84 | 0
HF | 5.25 | 500 | 0
RYAN | 50.5091369047619 | 1008 | 0
RYAN | 49.850525 | 400 | 0
HF | 36.5328125 | 384 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 0 | 0 | 0
HF | 4.358585858585859 | 99 | 0
HF | 22.5 | 320 | 0
HF | 1.349999956008492 | 11365.83 | 1.818989403545856e-12
HF | 1.359999676418601 | 12361.656 | 0.006000000001222361
HF | 1.279999753007985 | 14575.57 | 0.1999999999989086
HF | 3.719 | 11 | 1
HF | 9.6 | 1 | 0.45
HF | 5.25 | 788 | 1.799999999999955
RYAN | 24.37639348434716 | 1572 | 0.4000000000000909
RYAN | 28.88 | 2 | 0.5
HF | 15.11521065675341 | 1615 | 1
HF | 8.070169998026557 | 357 | 2.29000000000002
HF | 6.609115629421267 | 18 | 6.040760000000001
HF | 42.09862068965517 | 175 | 1
HF | 61.78147414741474 | 228 | 0.75
HF | 69.29508196721312 | 245 | 1
HF | 28.49004594180704 | 107 | 2.519999999999996
HF | 24.15 | 137 | 3.199999999999989
HF | 61.78270882310608 | 210 | 1.569999999999993
HF | 61.78686113494301 | 165 | 1.819999999999993
RYAN | 218.8000534616413 | 38 | 0.5900000000000034
HF | 101.006579253448 | 326 | 2.236535860275012
HF | 1.55 | 10202 | 254
HF | 38.49591928251121 | 248 | 25
HF | 38.50331658291457 | 267 | 68
HF | 39.56740318906606 | 522 | 83
HF | 64.10943942943688 | 383 | 62.21822148148152
HF | 50.20962962962963 | 309 | 120
HF | 1.019999670443748 | 25936.3 | 7730