Spreadsheet: 770843d1646299890-dynamic-sumifs-range-dynamic-offset-excelforum-support
Sheet: Sheet1

 |  |  |  |  |  |  |  | IDEAL SOLUTION
Mapping |  | Inside Sales | Field Sales | Enterprise Sales | [NAME] | Total
 | Sales |  |  |  |  |  |  |  | Inside Sales | Field Sales | Enterprise Sales | [NAME] | Total
Salaries | 49999 | 0 | 0 | 0 | 0 | 0 |  | Sales
Salaries |  | 0 | 0 | 0 | 0 | 0 |  | Salaries
Salaries |  | 0 | -16.99993544597938 | 0 | 0 | -16.99993544597938 |  | Rent
Salaries |  | -20.07053397907732 | -14.82236656975051 | -16.77744939720516 | 0 | -51.67034994603299 |  | Other
Salaries |  | 0.01887941599896907 | 0.007259578246391753 | 0.00290495943814433 | 0 | 0.02904395368350516
Salaries |  | 0 | 0 | 0 | 0 | 0 |  | Marketing
Salaries |  | 0 | 0 | 0 | 0 | 0 |  | Salaries
Salaries |  | -571.7233635304083 | -219.8936009239495 | -87.9574392414402 | 0 | -879.5744036957979 |  | Rent
Salaries |  | 0 | 0 | 0 | 0 | 0 |  | Other
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | -73.40527338432268 | -28.23279875720825 | -11.29312288730206 | 0 | -112.931195028833 |  | Analytics
Rent |  | -0.2025687443546391 | -0.145969981243299 | -0.1385299006628866 | 0 | -0.4870686262608248 |  | Salaries
Rent |  | 0 | 0 | 0 | 0 | 0 |  | Rent
Rent |  | 0 | 0 | 0 | 0 | 0 |  | Other
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | -0.9839577076319587 | -2.337646243015464 | -1.164826687018557 | 0 | -4.486430637665979
Rent |  | -2.452784169328866 | -10.61320443923402 | -7.565061524627835 | 0 | -20.63105013319072
Rent |  | -12.96618556701031 | -9.342628865979382 | -8.865876288659793 | 0 | -31.17469072164948
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | -4.327525773195876 | -3.118195876288659 | -2.959020618556701 | 0 | -10.40474226804124
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | -0.09157109032783504 | -15.13347926452887 | -0.0955082974886598 | 0 | -15.32055865234536
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | -1.569783673393814 | -1.13119684591134 | -1.073453021118557 | 0 | -3.774433540423711
Rent |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | -139.1749313942072 | -247.5589567499763 | -70.3510385159433 | 0 | -457.0849266601267
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 33.42806770127113 | 17.28926376532062 | 12.13474886386082 | 0 | 62.85208033045257
Other |  | -9.099410333574227 | -65.55960970006392 | -4.088541445807217 | 0 | -78.74756147944537
Other |  | 0 | 17.11335860011959 | 0 | 0 | 17.11335860011959
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0.8300963899731959 | -4.565084529715464 | -3.033849386030928 | 0 | -6.768837525773197
Other |  | -1.469796661742268 | -12.80116912176289 | -3.204271792836082 | 0 | -17.47523757634124
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | -18.38205873966907 | -23.50764250140412 | -8.84862490324433 | 0 | -50.73832614431753
Other |  | -36.25471732994021 | -94.54962138918661 | -19.8123366716567 | 0 | -150.6166753907835
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 5.377017872327835 | 0 | 0 | 5.377017872327835
Other |  | -0.4618152215917525 | -5.445828746475257 | 0.4169096253061856 | 0 | -5.490734342760825
Other |  | -4.459501945709278 | -5.702976884079381 | -2.146680414319587 | 0 | -12.30915924410825
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | -0.2088186376701031 | -0.185054377256701 | -0.1973623801577319 | 0 | -0.5912353950845362
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | -0.1448982486350515 | -0.05573009562886598 | -0.02229203825154639 | 0 | -0.2229203825154639
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
 | Total Sales | -863.1724526245474 | -741.9157974926239 | -237.0407219637227 | 0 | -1842.128972080894
 | Marketing
Salaries | 54100 | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | -4.484309735241237 | -4.484309735241237
Salaries |  | 0 | 0 | 0 | -28.6863334342268 | -28.6863334342268
Salaries |  | -0.6388428856824742 | 0 | 0 | -50.08035001122887 | -50.71919289691134
Salaries |  | 0 | 0 | 0 | -0.5041091747319587 | -0.5041091747319587
Salaries |  | 0 | 0 | 0 | -1.330099136606186 | -1.330099136606186
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | -0.6768837525773196 | 0 | 0 | 0 | -0.6768837525773196
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | -1.711658507934021 | 0 | 0 | -7.710625375619587 | -9.422283883553607
Salaries |  | -9.81631483802268 | 0 | 0 | -44.22005970235258 | -54.03637454037526
Salaries |  | 0 | 0 | 0 | -278.4751483303185 | -278.4751483303185
Salaries |  | -190.7964893030752 | 0 | 0 | -285.1318544217794 | -475.9283437248546
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 132.9230469123711 | 0 | 0 | 138.9867971958763 | 271.9098441082474
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | -45.84513349693609 | -45.84513349693609
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | -284.6338484822165 | 0 | 0 | -1111.153263187011 | -1395.787111669228
Salaries |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 2.331097392709278 | 0 | 0 | 104.1513302334546 | 106.4824276261639
Rent |  | -58.72085008264948 | 0 | 0 | -256.9239029389886 | -315.6447530216382
Rent |  | 0 | 0 | 0 | -12.86079129896907 | -12.86079129896907
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0.3684052637360825 | 0 | 0 | 0.7766112921237113 | 1.145016555859794
Rent |  | -5.511007011150515 | 0 | 0 | -52.8400501960701 | -58.35105720722062
Rent |  | 18.90706670026185 | 0 | 0 | 61.70315477092165 | 80.61022147118351
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | -32.03297644302165 | 0 | 0 | -99.8390617853268 | -131.8720382283485
Rent |  | -108.7654211468567 | 0 | 0 | -417.5246813686629 | -526.2901025155196
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 5.94059692542165 | 0 | 0 | 19.38714086107938 | 25.32773778650103
Rent |  | -7.771189549381443 | 0 | 0 | -24.22093131847422 | -31.99212086785567
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -0.1994155942072165 | -0.1994155942072165
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 2.820348969072165 | 0 | 0 | -3.310993797825773 | -0.4906448287536082
Rent |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -0.2229203825154639 | -0.2229203825154639
Other |  | 0 | 0 | 0 | -74.13853591279175 | -74.13853591279175
Other |  | 266.5763611426062 | 0 | 0 | 805.9958988370969 | 1072.572259979703
Other |  | 0 | 0 | 0 | -505.9722972609279 | -505.9722972609279
 | Total Marketing | -271.2085586963896 | 0 | 0 | -2174.67393467026 | -2445.88249336665
 | Analytics
Salaries | 55200 | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | -183.4834372402299 | -183.4834372402299
Salaries |  | 0 | 0 | 0 | -5.38659793814433 | -5.38659793814433
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | -13.61382447371134 | -13.61382447371134
Salaries |  | 0 | 0 | 0 | -155.3492335767588 | -155.3492335767588
Salaries |  | 0 | 0 | 0 | 0 | 0
Salaries |  | 0 | 0 | 0 | -3.585966540914433 | -3.585966540914433
Salaries |  | 0 | 0 | 0 | -4.650332397654639 | -4.650332397654639
Salaries |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -78.15104075039278 | -78.15104075039278
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -3.340866934106185 | -3.340866934106185
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -3.250863957805155 | -3.250863957805155
Rent |  | 0 | 0 | 0 | -18.64353329259175 | -18.64353329259175
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -33.84418762886598 | -33.84418762886598
Rent |  | 0 | 0 | 0 | 0 | 0
Rent |  | 0 | 0 | 0 | -10.15043593969072 | -10.15043593969072
Rent |  | 0 | 0 | 0 | -250.0389121612732 | -250.0389121612732
Other |  | 0 | 0 | 0 | -273.6120995727186 | -273.6120995727186
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -28.93378042996185 | -28.93378042996185
Other |  | 0 | 0 | 0 | -16.92209381443299 | -16.92209381443299
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -6.249329245670102 | -6.249329245670102
Other |  | 0 | 0 | 0 | -1.001263368906186 | -1.001263368906186
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -9.534454802751547 | -9.534454802751547
Other |  | 0 | 0 | 0 | -5.866325855670103 | -5.866325855670103
Other |  | 0 | 0 | 0 | -545.1153565328866 | -545.1153565328866
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -1.173265171134021 | -1.173265171134021
Other |  | 0 | 0 | 0 | 16.07226626307217 | 16.07226626307217
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -340.6808498026433 | -340.6808498026433
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -20.16387060785979 | -20.16387060785979
Other |  | 0 | 0 | 0 | -53.03872685884742 | -53.03872685884742
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -70.94873251016702 | -70.94873251016702
Other |  | 0 | 0 | 0 | -279.9713998653907 | -279.9713998653907
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -16.66477081519278 | -16.66477081519278
Other |  | 0 | 0 | 0 | -17.21215542450619 | -17.21215542450619
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -0.5033984467917526 | -0.5033984467917526
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | -81.22605030927835 | -81.22605030927835
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 5.288659793814433 | 5.288659793814433
Other |  | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0
 | Total Analytics | 0 | 0 | 0 | -2510.946230210062 | -2510.946230210062