Spreadsheet: 669241d1585258231-sumif-with-stratification-help-stratification
Sheet: Data

Sales Org | Zone Sales Manager | Sold To Customer | O2O Quote Number | Revenue Type | Sales Channel Name | Invoice Gross List Price, Plus Surcharges | Invoice Total Discount $ | Trade In's | Invoice Price | Invoice Total Discount %
6100 | N/A | [PHONE] | 1022536-13 | Software | Indirect Sales | 953648.3409164482 | 859245.6005030121 | -1508100.128160424 | -1413697.389634436 | 0.901008855819205
6000 | EMEA | [PHONE] | 1007410-1 | Software | Direct Sales | 0 | 0 | -107124.0789104968 | -107124.0789104968 | 0
6200 | EMEA | [PHONE] | 1007468-6 | Training | Direct Sales | 1756.2825 | 1058.9881598328 | -15797.2603554687 | -15099.9660153015 | 0.602971423921131
8100 | N/A | [PHONE] | 898565-2 | Software | Direct Sales | 36690.777 | 13699.2 | -36439.872 | -13448.295 | 0.373369034948483
8100 | Germany | [PHONE] | 1070233-2 | Training | Direct Sales | 0 | 0 | -8364.8574873047 | -8364.8574873047 | 0
8100 | Germany | [PHONE] | 984225-8 | Software | Direct Sales | 7423.3972934463 | 742.3397091751 | -14146.6043269226 | -7465.5467426514 | 0.099999997282979
6800 | EMEA | [PHONE] | 976483-12 | Training | Direct Sales | 0 | 0 | -877.2295733887 | -877.2295733887 | 0
5000 | Americas | [PHONE] | 988933-13 | Training | Direct Sales | 0 | 0 | -840 | -840 | 0
6400 | EMEA | [PHONE] | 963180-8 | Training | Direct Sales | 0 | 0 | -376.4540271484 | -376.4540271484 | 0
5000 | Americas | [PHONE] | 981256-9 | Software | Direct Sales | 688500 | 149346.75 | -539153.28125 | -0.03125 | 0.216916122004357
2410 | Asia/Pacific | [PHONE] | 1075042-1 | Software | Direct Sales | 2566838.923739999 | 2032537.741046161 | -534301.2017333594 | -0.0190395214 | 0.791844677999764
6100 | EMEA | [PHONE] | 1040402-9 | Software | Direct Sales | 698169.912 | 573432.59716 | -124737.3180825 | -0.0032425 | 0.821336736665329
1300 | Asia/Pacific | [PHONE] | 1018797-17 | Software | Direct Sales | 517500 | 323690.40625 | -193809.5968780518 | -0.0031280518 | 0.625488707729469
2410 | Asia/Pacific | [PHONE] | 1036320-5 | Software | Indirect Sales | 355615.029 | 216802.29193875 | -138812.7400660547 | -0.0030048047 | 0.609654469746131
8100 | N/A | [PHONE] | 961156-2 | Software | Direct Sales | 192909.9403875 | 0 | -192909.9430875122 | -0.0027000122 | 0
6200 | EMEA | [PHONE] | 1051753-10 | Software | Direct Sales | 310772.748 | 155505.8568679688 | -155266.8936509399 | -0.0025189087 | 0.500384470223782
6500 | EMEA | [PHONE] | 937221-24 | Software | Direct Sales | 485970.6159 | 399046.3428779297 | -86924.2752 | -0.0021779297 | 0.821132656629682
6500 | N/A | [PHONE] | 1066507-5 | Software | Indirect Sales | 118984.479 | 85008.9834282654 | -33975.4976496277 | -0.0020778931 | 0.714454390545051
7600 | N/A | [PHONE] | 918963-6 | Software | Direct Sales | 175539.95 | 95628.3850683594 | -79911.5665390015 | -0.0016073608 | 0.544767074779042
6000 | N/A | [PHONE] | 972181-7 | Software | Indirect Sales | 104205.27984 | 62878.7928431348 | -41326.4885947412 | -0.001597876 | 0.603412734361261
6900 | EMEA | [PHONE] | 1009307-3 | Software | Direct Sales | 129007.0341 | 72124.6242712555 | -56882.4114111465 | -0.001582402 | 0.559075129309213
6200 | EMEA | [PHONE] | 948528-6 | Software | Direct Sales | 106451.9168 | 55739.6701828125 | -50712.2477320312 | -0.0011148438 | 0.523613588729785
8100 | N/A | [PHONE] | 961871-1 | Software | Direct Sales | 34830.216 | 20013.7095601563 | -14816.5075546875 | -0.0011148437 | 0.574607678578745
6500 | EMEA | [PHONE] | 1003875-5 | Software | Indirect Sales | 62772.08 | 29423.0355644531 | -33349.045546875 | -0.0011113281 | 0.468728064522525
6500 | N/A | [PHONE] | 998403-4 | Software | Indirect Sales | 101712.7314 | 73090.8803707031 | -28621.8521182617 | -0.0010889648 | 0.718601097076655
6500 | EMEA | [PHONE] | 1013755-7 | Software | Direct Sales | 60355.884 | 23610.771896875 | -36745.1131808594 | -0.0010777344 | 0.391192545483635
7400 | EMEA | [PHONE] | 1028778-3 | Software | Direct Sales | 97956.1454 | 28104.3010978516 | -69851.8453746094 | -0.0010724609 | 0.286906972330207
5000 | N/A | [PHONE] | 984390-2 | Software | Indirect Sales | 88637 | 38717.0014648438 | -49919.9995117188 | -0.0009765625 | 0.436804059984473
3012 | N/A | [PHONE] | 991028-4 | Software | Indirect Sales | 261304.91751 | 222411.9197133454 | -38892.9987137402 | -0.0009170856 | 0.851158569202333
5000 | Americas | [PHONE] | 981249-5 | Software | Direct Sales | 109960 | 94914.1604003906 | -15045.8403320313 | -0.0007324219 | 0.863169883597587
7700 | EMEA | [PHONE] | 944558-2 | Software | Indirect Sales | 66756.4754578125 | 47692.6950125 | -19063.781490625 | -0.000696875 | 0.714427996466649
7700 | EMEA | [PHONE] | 1040029-12 | Software | Indirect Sales | 234667.7501 | 130045.0186702392 | -104622.7320943725 | -0.0006646118 | 0.55416655511813
6000 | N/A | [PHONE] | 1045556-2 | Software | Indirect Sales | 61053.46956 | 30539.8641742188 | -30513.6059860645 | -0.0006002832 | 0.500215047470903
6460 | N/A | [PHONE] | 1035912-1 | Software | Direct Sales | 252904.687 | 168140.4244000391 | -84764.263178125 | -0.0005781641 | 0.664837122611488
6800 | EMEA | [PHONE] | 945918-1 | Software | Indirect Sales | 67380.5664 | 46492.67195 | -20887.8950109375 | -0.0005609375 | 0.690001204115732
6800 | EMEA | [PHONE] | 983033-3 | Software | Indirect Sales | 28198.6866 | 16979.7893791016 | -11218.8977686523 | -0.0005477539 | 0.602148235482058
8100 | N/A | [PHONE] | 999348-4 | Software | Direct Sales | 47848.941 | 26019.9219902344 | -21829.019554248 | -0.0005444824 | 0.543793058873223
6500 | EMEA | [PHONE] | 992583-7 | Software | Direct Sales | 71834.742 | 39718.2563213379 | -32116.4862231445 | -0.0005444824 | 0.55291151907162
6500 | EMEA | [PHONE] | 1066394-5 | Software | Direct Sales | 42006.15 | 27788.2380117676 | -14217.9125244629 | -0.0005362305 | 0.661527847988154
7800 | EMEA | [PHONE] | 1064304-4 | Software | Indirect Sales | 34533.94 | 23965.6390910889 | -10568.3014366333 | -0.0005277222 | 0.693973496539603
6100 | EMEA | [PHONE] | 976210-7 | Software | Direct Sales | 122439.042 | 93622.7148878125 | -28816.3276239551 | -0.0005117676 | 0.764647561419278
7800 | EMEA | [PHONE] | 1060408-5 | Software | Indirect Sales | 31156.836 | 20668.8533496094 | -10487.9831470703 | -0.0004966797 | 0.663381010498286
3012 | N/A | [PHONE] | 996829-4 | Software | Indirect Sales | 27236.88 | 18475.4528835937 | -8761.42760625 | -0.0004898438 | 0.678324862597836
5000 | N/A | [PHONE] | 975204-5 | Software | Indirect Sales | 33153 | 21497.6401367188 | -11655.3603515625 | -0.0004882813 | 0.648437249622018
5000 | Americas | [PHONE] | 981265-3 | Software | Direct Sales | 156723 | 141047.6401367188 | -15675.3603515625 | -0.0004882813 | 0.899980475978119
5000 | N/A | [PHONE] | 1042719-3 | Software | Indirect Sales | 40708 | 17504.4399414063 | -23203.560546875 | -0.0004882813 | 0.429999998560633
6460 | EMEA | [PHONE] | 950022-4 | Software | Direct Sales | 378018 | 356656.8001670837 | -21361.2003173828 | -0.0004844666 | 0.943491580208042
7700 | EMEA | [PHONE] | 969453-2 | Software | Direct Sales | 204510.705 | 160490.8975810547 | -44019.8078303833 | -0.000411438 | 0.784755485445394
6100 | N/A | [PHONE] | 992174-2 | Software | Indirect Sales | 51283.533 | 27054.7150229688 | -24228.8183864453 | -0.0004094141 | 0.527551700132843
6900 | EMEA | [PHONE] | 1064716-3 | Software | Direct Sales | 43272.3746 | 13246.7082544922 | -30025.6667476807 | -0.0004021728 | 0.306123904152285
5000 | Americas | [PHONE] | 984355 | Software | Direct Sales | 290415 | 274429.3203125 | -15985.6800689697 | -0.0003814697 | 0.944955736833497
3012 | N/A | [PHONE] | 1038776-3 | Software | Indirect Sales | 27377.71715 | 18369.9086904114 | -9007.8087825928 | -0.0003230042 | 0.670980293563716
6000 | N/A | [PHONE] | 964337-7 | Software | Indirect Sales | 26857.65164 | 17889.7775692432 | -8967.874390332 | -0.0003195752 | 0.666096120727075
6000 | N/A | [PHONE] | 980287-5 | Software | Indirect Sales | 43062.58236 | 18773.9749352148 | -24288.6077423315 | -0.0003175464 | 0.435969556546001
6000 | N/A | [PHONE] | 943729-2 | Software | Indirect Sales | 21189.12 | 10566.75875 | -10622.3615625 | -0.0003125 | 0.49868794692748
6900 | EMEA | [PHONE] | 1043644-3 | Software | Direct Sales | 49238.2176 | 35335.1585361328 | -13903.0593361816 | -0.0002723145 | 0.717636832900564
6500 | N/A | [PHONE] | 1015075-8 | Software | Indirect Sales | 29267.472 | 24466.5471467773 | -4800.9251226562 | -0.0002694336 | 0.835963801273214
6500 | N/A | [PHONE] | 957643-5 | Software | Indirect Sales | 31728.4888 | 25529.3268445679 | -6199.1622167236 | -0.0002612915 | 0.804618430001238
7800 | EMEA | [PHONE] | 1012912-7 | Software | Indirect Sales | 41944.0026 | 30547.2916201172 | -11396.7112336523 | -0.0002537695 | 0.728287472023883
5000 | N/A | [PHONE] | 1019452-2 | Software | Indirect Sales | 27054 | 22284.7202148438 | -4769.2800292969 | -0.0002441406 | 0.823712582791593
5000 | N/A | [PHONE] | 987753-4 | Software | Direct Sales | 14520 | 0 | -14520.0002441406 | -0.0002441406 | 0
5000 | N/A | [PHONE] | 974668-2 | Software | Indirect Sales | 29680 | 15138.8798828125 | -14541.1203613281 | -0.0002441406 | 0.510070076914168
5000 | Americas | [PHONE] | 928746-9 | Software | Direct Sales | 30948 | 13462.80078125 | -17485.1994628906 | -0.0002441406 | 0.435013596395567
5000 | Americas | [PHONE] | 1000800-9 | Software | Direct Sales | 24516 | 6316.80078125 | -18199.1994628906 | -0.0002441406 | 0.257660335342225
5000 | N/A | [PHONE] | 984896-5 | Software | Indirect Sales | 93639 | 59191.3200683594 | -34447.6801757813 | -0.0002441406 | 0.632122513785489
8100 | N/A | [PHONE] | 961169-2 | Software | Direct Sales | 14162.506765625 | 0 | -14162.5069760191 | -0.0002103941 | 0
6500 | EMEA | [PHONE] | 944090-2 | Software | Direct Sales | 31822.985 | 21451.4837298584 | -10371.5014797974 | -0.0002096558 | 0.674087730294892
6000 | EMEA | [PHONE] | 938114-2 | Software | Direct Sales | 82905.6 | 66102.9889453125 | -16802.61125 | -0.0001953125 | 0.797328394527179
5400 | N/A | [PHONE] | 976344-2 | Software | Indirect Sales | 19835.767 | 13061.062 | -6774.7051828613 | -0.0001828613 | 0.658460144243477
7700 | EMEA | [PHONE] | 983660-5 | Software | Indirect Sales | 50096.562 | 27563.274 | -22533.2881707813 | -0.0001707812 | 0.550202906139547
6100 | N/A | [PHONE] | 954078-3 | Software | Indirect Sales | 382942.4899999999 | 363608.6236953124 | -19333.8664669189 | -0.0001622314 | 0.949512350262601
6000 | N/A | [PHONE] | 946410-3 | Software | Indirect Sales | 68899.1435 | 39891.2203385071 | -29007.9233216174 | -0.0001601245 | 0.578979916325187
7800 | EMEA | [PHONE] | 987842-3 | Software | Indirect Sales | 43458.8583 | 39226.6402304004 | -4232.2182133502 | -0.0001437506 | 0.90261552569135
8100 | N/A | [PHONE] | 1018133-2 | Software | Direct Sales | 7841.3832 | 1217.6893361206 | -6623.694 | -0.0001361206 | 0.155290119748338
7600 | N/A | [PHONE] | 1035166-2 | Software | Indirect Sales | 5132.8436 | 2099.6211609131 | -3033.2225738037 | -0.0001347168 | 0.409056134286477
6800 | EMEA | [PHONE] | 977193-5 | Software | Direct Sales | 42587.924 | 29936.9600548828 | -12650.964079834 | -0.0001347168 | 0.702944807896314
6900 | EMEA | [PHONE] | 1012475-8 | Software | Direct Sales | 12315.1644 | 5073.2591752407 | -7241.9053481186 | -0.0001233593 | 0.411952208712756
5000 | Americas | [PHONE] | 998080-8 | Software | Direct Sales | 64253 | 56582.8400878906 | -7670.1600341797 | -0.0001220703 | 0.880625653088426
5000 | Americas | [PHONE] | 950637-8 | Software | Direct Sales | 15320 | 88.759765625 | -15231.2403564453 | -0.0001220703 | 0.005793718382833
6000 | N/A | [PHONE] | 1068582-7 | Software | Indirect Sales | 7901.63388 | 4785.5141289578 | -3116.1198690161 | -0.0001179739 | 0.605636024350678
6000 | N/A | [PHONE] | 943261-1 | Software | Indirect Sales | 10160.64 | 7709.1840625 | -2451.456015625 | -7.8125e-05 | 0.758730164881346
6000 | N/A | [PHONE] | 1013430-4 | Software | Indirect Sales | 29794.51363 | 19764.1214654681 | -10030.3922420044 | -7.74725e-05 | 0.663347679069603
6000 | N/A | [PHONE] | 1030679-8 | Software | Indirect Sales | 60715.25025 | 48697.6153291992 | -12017.6349951764 | -7.43756e-05 | 0.802065628135976
8100 | N/A | [PHONE] | 953325-3 | Software | Indirect Sales | 47859.008 | 46724.3152976562 | -1134.6927724609 | -7.01172e-05 | 0.976290927251485
7600 | N/A | [PHONE] | 1035203-2 | Software | Indirect Sales | 5132.8436 | 2099.6210935547 | -3033.2225738037 | -6.73584e-05 | 0.409056121163459
6800 | EMEA | [PHONE] | 1011672-1 | Software | Direct Sales | 16044.1368 | 12819.1527467773 | -3224.9841205811 | -6.73584e-05 | 0.798992984575982
7800 | EMEA | [PHONE] | 1021681-4 | Software | Indirect Sales | 6744.35475 | 2765.1855089966 | -3979.1693025 | -6.14966e-05 | 0.410000009118231
5000 | N/A | [PHONE] | 1038718-5 | Software | Indirect Sales | 15030 | 11691.6000366211 | -3338.4000244141 | -6.10352e-05 | 0.777884233973459
1510 | Asia/Pacific | [PHONE] | 1022069-17 | Software | Indirect Sales | 40958 | 36364.8800048828 | -4593.1200561523 | -6.10352e-05 | 0.887857805676127
1510 | N/A | [PHONE] | 1017069-2 | Software | Indirect Sales | 12610 | 7992 | -4618.0000610352 | -6.10352e-05 | 0.633782712133228
5000 | N/A | [PHONE] | 965407-11 | Software | Direct Sales | 308949 | 230515.5594482422 | -78433.440612793 | -6.10352e-05 | 0.746128194129912
8100 | N/A | [PHONE] | 961144-2 | Software | Direct Sales | 5315.8375457031 | 0 | -5315.8376066711 | -6.0968e-05 | 0
7700 | EMEA | [PHONE] | 879211-9 | Software | Direct Sales | 226561.936 | 155832.4182452637 | -70729.5178113495 | -5.66132e-05 | 0.687813765173968
6460 | EMEA | [PHONE] | 944578-5 | Software | Indirect Sales | 276768 | 261536.4002571106 | -15231.5997924805 | -4.95911e-05 | 0.94496618199037
6000 | N/A | [PHONE] | 939970-4 | Software | Indirect Sales | 49491.2 | 28262.1437988281 | -21229.05625 | -4.88281e-05 | 0.571053920673334
6000 | N/A | [PHONE] | 975651-6 | Software | Indirect Sales | 38374.05768 | 29037.3651120319 | -9336.692607915 | -3.99469e-05 | 0.756692590451953
6000 | N/A | [PHONE] | 1039667-7 | Software | Indirect Sales | 10464.48256 | 9173.9286085738 | -1290.5539795645 | -2.81383e-05 | 0.87667293207986
6500 | N/A | [PHONE] | 939415-1 | Software | Indirect Sales | 120408.2 | 119550.824013977 | -857.3760034943 | -1.74713e-05 | 0.992879421949477
6500 | N/A | [PHONE] | 959165-14 | Software | Indirect Sales | 64165.9112 | 54997.3107800781 | -9168.6004373413 | -1.74194e-05 | 0.857111038424373
6500 | EMEA | [PHONE] | 996213-5 | Software | Direct Sales | 76621.54 | 70091.7871289062 | -6529.7528884583 | -1.73645e-05 | 0.914779148642878