Spreadsheet: 193442d1352833071-could-anyone-help-me-simplify-a-very-long-and-drawn-out-process-ef263_october-sales-analysis-revised
Sheet: sk

Invoice Date |  | Order date |  | Salesperson No. | Gross profit | Total
2012-09-28 00:00:00 |  | 2012-09-27 00:00:00 |  | VAUGHN | 72.2 | 282.74
2012-09-28 00:00:00 |  | 2012-09-27 00:00:00 |  | VAUGHN | 9.5 | 15
2012-09-28 00:00:00 |  | 2012-09-28 00:00:00 |  | 3000 | 14.65 | -45.31
2012-09-28 00:00:00 |  | 2012-09-18 00:00:00 |  | [PHONE] | 1629.45 | 4407.54
2012-09-28 00:00:00 |  | 2012-09-10 00:00:00 |  | NOLAN | 223.15 | 677.25
2012-09-28 00:00:00 |  | 2012-09-11 00:00:00 |  | VAUGHN | 12521.79 | 54374.38
2012-09-28 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 12.64 | 60.9
2012-09-28 00:00:00 |  | 2012-08-30 00:00:00 |  | VAUGHN | 689.82 | 1906.42
2012-09-28 00:00:00 |  | 2012-09-19 00:00:00 |  | VAUGHN | 395.23 | 1046.12
2012-09-28 00:00:00 |  | 2012-09-27 00:00:00 |  | VAUGHN | 1.28 | 4.27
2012-09-28 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 348.43 | 1100.73
2012-09-28 00:00:00 |  | 2012-09-05 00:00:00 |  | ERNIE | 2839.17 | 11970
2012-10-01 00:00:00 |  | 2012-07-06 00:00:00 |  | VAUGHN | 330.15 | 1133.84
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | VAUGHN | -98.04 | -370.14
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | VAUGHN | 85.01 | 323.1
2012-10-01 00:00:00 |  | 2012-09-27 00:00:00 |  | NOLAN | 253.42 | 791.93
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 3000 | 0.69 | 1.46
2012-10-01 00:00:00 |  | 2012-09-24 00:00:00 |  | ERNIE | 12621.81 | 48275
2012-10-01 00:00:00 |  | 2012-09-19 00:00:00 |  | VAUGHN | 214.33 | 627.9
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 55.63 | 69.45
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 67.02 | 324.27
2012-10-01 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 24.12 | 72.32
2012-10-01 00:00:00 |  | 2012-09-17 00:00:00 |  | VAUGHN | 258.37 | 955.08
2012-10-01 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 63.81 | 111.22
2012-10-02 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 323.09 | 1486.02
2012-10-02 00:00:00 |  | 2012-10-01 00:00:00 |  | VAUGHN | 85.94 | 386.14
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 419.9 | 1789.82
2012-10-02 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 52.36 | 60.19
2012-10-02 00:00:00 |  | 2012-09-17 00:00:00 |  | VAUGHN | 5.09 | 14.62
2012-10-02 00:00:00 |  | 2012-07-05 00:00:00 |  | VAUGHN | 635.81 | 2108.14
2012-10-02 00:00:00 |  | 2012-05-23 00:00:00 |  | VAUGHN | 111.81 | 390.1
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 6.61 | 17.61
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | VAUGHN | 361.27 | 1082.81
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 7.28 | 30.09
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | ERNIE | 51.78 | 198.14
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 190.86 | 738.36
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 110.77 | 369.6
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | VAUGHN | 25.99 | 93.44
2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 288.5 | 1074.91
2012-10-03 00:00:00 |  | 2012-10-03 00:00:00 |  | 3000 | 0.47 | 0.94
2012-10-03 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 577 | 1848
2012-10-03 00:00:00 |  | 2012-08-23 00:00:00 |  | NOLAN | 113.07 | 394.51
2012-10-03 00:00:00 |  | 2012-10-02 00:00:00 |  | VAUGHN | 155.03 | 473.57
2012-10-03 00:00:00 |  | 2012-10-03 00:00:00 |  | VAUGHN | 35.87 | 167.69
2012-10-03 00:00:00 |  | 2012-09-26 00:00:00 |  | RON | 59.66 | 188.72
2012-10-03 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 86.62 | 320.67
2012-10-03 00:00:00 |  | 2012-09-25 00:00:00 |  | NOLAN | 50.02 | 151.21
2012-10-03 00:00:00 |  | 2012-10-03 00:00:00 |  | NOLAN | 235.63 | 669.9
2012-10-03 00:00:00 |  | 2012-10-03 00:00:00 |  | NOLAN | -9.27 | 70.82
2012-10-04 00:00:00 |  | 2012-10-03 00:00:00 |  | NOLAN | 106.74 | 372.41
2012-10-04 00:00:00 |  | 2012-10-04 00:00:00 |  | ERNIE | -108.21 | -423.74
2012-10-04 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 6.45 | 25.23
2012-10-04 00:00:00 |  | 2012-10-04 00:00:00 |  | NOLAN | 814.76 | 2703.75
2012-10-04 00:00:00 |  | 2012-06-14 00:00:00 |  | NOLAN | 6.27 | 18.69
2012-10-04 00:00:00 |  | 2012-10-04 00:00:00 |  | VAUGHN | 33.27 | 84.16
2012-10-04 00:00:00 |  | 2012-10-04 00:00:00 |  | VAUGHN | 2.65 | 12.45
2012-10-04 00:00:00 |  | 2012-10-04 00:00:00 |  | NOLAN | 115.87 | 345.43
2012-10-05 00:00:00 |  | 2012-10-05 00:00:00 |  | NOLAN | 92.58 | 337.17
2012-10-05 00:00:00 |  | 2012-10-05 00:00:00 |  | 3000 | 3.58 | 9.11
2012-10-05 00:00:00 |  | 2012-09-13 00:00:00 |  | VAUGHN | 9388.02 | 43079.42
2012-10-05 00:00:00 |  | 2012-10-02 00:00:00 |  | VAUGHN | 209.08 | 633.78
2012-10-05 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 13.69 | 32.36
2012-10-05 00:00:00 |  | 2012-10-05 00:00:00 |  | VAUGHN | 3.94 | 16.79
2012-10-05 00:00:00 |  | 2012-09-28 00:00:00 |  | NOLAN | 9.64 | 17.67
2012-10-05 00:00:00 |  | 2012-10-05 00:00:00 |  | [PHONE] | -14.78 | 0
2012-10-09 00:00:00 |  | 2012-09-27 00:00:00 |  | NOLAN | 32.86 | 101.91
2012-10-09 00:00:00 |  | 2012-10-09 00:00:00 |  | VAUGHN | -33.27 | -84.16
2012-10-09 00:00:00 |  | 2012-10-09 00:00:00 |  | NOLAN | 48.91 | 144.9
2012-10-09 00:00:00 |  | 2012-10-09 00:00:00 |  | VAUGHN | 42.93 | 222.31
2012-10-09 00:00:00 |  | 2012-08-13 00:00:00 |  | 3000 | 114.96 | 211.86
2012-10-09 00:00:00 |  | 2012-09-14 00:00:00 |  | VAUGHN | 104.8 | 287.83
2012-10-09 00:00:00 |  | 2012-10-09 00:00:00 |  | NOLAN | 54.96 | 188.79
2012-10-09 00:00:00 |  | 2012-10-09 00:00:00 |  | ERNIE | 36.08 | 114.33
2012-10-10 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 50.61 | 144.98
2012-10-10 00:00:00 |  | 2012-10-09 00:00:00 |  | NOLAN | 634.92 | 2029.49
2012-10-10 00:00:00 |  | 2012-10-09 00:00:00 |  | NOLAN | 25.16 | 76.97
2012-10-10 00:00:00 |  | 2012-10-10 00:00:00 |  | NOLAN | 2.67 | 8.56
2012-10-11 00:00:00 |  | 2012-10-09 00:00:00 |  | NOLAN | 319.57 | 1010.63
2012-10-11 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 27.66 | 67.35
2012-10-11 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 14.37 | 35.06
2012-10-11 00:00:00 |  | 2012-09-11 00:00:00 |  | NOLAN | 251.07 | 862.31
2012-10-11 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 5.05 | 24.15
2012-10-11 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 34.21 | 117.5
2012-10-11 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 65.75 | 227.1
2012-10-12 00:00:00 |  | 2012-10-12 00:00:00 |  | NOLAN | 3.38 | 8.59
2012-10-12 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 492.5 | 1788.84
2012-10-12 00:00:00 |  | 2012-10-10 00:00:00 |  | NOLAN | 403.02 | 1386
2012-10-12 00:00:00 |  | 2012-10-12 00:00:00 |  | VAUGHN | 92.46 | 274.64
2012-10-12 00:00:00 |  | 2012-10-12 00:00:00 |  | NOLAN | 2.23 | 6.46
2012-10-12 00:00:00 |  | 2012-10-12 00:00:00 |  | VAUGHN | 67.26 | 229.93
2012-10-15 00:00:00 |  | 2012-09-20 00:00:00 |  | VAUGHN | 636.36 | 2108.14
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | NOLAN | 48.19 | 162.8
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | NOLAN | -32.86 | -101.91
2012-10-15 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 1421.53 | 5052.3
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 5.51 | 20.29
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 23.73 | 121.28
2012-10-15 00:00:00 |  | 2012-09-19 00:00:00 |  | VAUGHN | 240.37 | 535.5
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 524.04 | 2475.9
2012-10-15 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 26.07 | 123.09
2012-10-16 00:00:00 |  | 2012-10-15 00:00:00 |  | NOLAN | 726.99 | 2536.38
2012-10-16 00:00:00 |  | 2012-09-18 00:00:00 |  | VAUGHN | 4694.01 | 21539.72
2012-10-16 00:00:00 |  | 2012-10-10 00:00:00 |  | NOLAN | 1152.22 | 4586.16
2012-10-16 00:00:00 |  | 2012-10-10 00:00:00 |  | NOLAN | 1152.22 | 4586.16
2012-10-16 00:00:00 |  | 2012-10-04 00:00:00 |  | ERNIE | 5889.39 | 19433.75
2012-10-16 00:00:00 |  | 2012-09-27 00:00:00 |  | ERNIE | 5606.99 | 28733.75
2012-10-16 00:00:00 |  | 2012-10-16 00:00:00 |  | NOLAN | 14.93 | 55
2012-10-17 00:00:00 |  | 2012-10-17 00:00:00 |  | VAUGHN | 1.77 | 5.06
2012-10-17 00:00:00 |  | 2012-10-15 00:00:00 |  | NOLAN | 53.47 | 249.65
2012-10-17 00:00:00 |  | 2012-09-17 00:00:00 |  | VAUGHN | 136.92 | 706.49
2012-10-17 00:00:00 |  | 2012-09-20 00:00:00 |  | VAUGHN | 442.5 | 1692.18
2012-10-18 00:00:00 |  | 2012-10-01 00:00:00 |  | NOLAN | 177.43 | 793.54
2012-10-18 00:00:00 |  | 2012-10-18 00:00:00 |  | VAUGHN | 11.98 | 46.27
2012-10-18 00:00:00 |  | 2012-10-15 00:00:00 |  | ERNIE | 1159.66 | 3637.44
2012-10-18 00:00:00 |  | 2012-10-16 00:00:00 |  | ERNIE | 428.78 | 1241.46
2012-10-18 00:00:00 |  | 2012-10-12 00:00:00 |  | VAUGHN | 1629.43 | 6806.42
2012-10-18 00:00:00 |  | 2012-10-09 00:00:00 |  | VAUGHN | 5.59 | 25.31
2012-10-18 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 3.57 | 16.28
2012-10-18 00:00:00 |  | 2012-10-17 00:00:00 |  | RON | 257.74 | 998.71
2012-10-18 00:00:00 |  | 2012-10-15 00:00:00 |  | NOLAN | 538.48 | 1647.6
2012-10-18 00:00:00 |  | 2012-08-31 00:00:00 |  |  | 449.31 | 2398.2
2012-10-18 00:00:00 |  | 2012-10-12 00:00:00 |  | ERNIE | 150.74 | 706.02
2012-10-18 00:00:00 |  | 2012-10-18 00:00:00 |  | [NAME] | 154.03 | 701.52
2012-10-19 00:00:00 |  | 2012-10-19 00:00:00 |  |  | 9.56 | 30.89
2012-10-19 00:00:00 |  | 2012-10-18 00:00:00 |  | VAUGHN | 44.84 | 203.7
2012-10-19 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 106.89 | 241.81
2012-10-19 00:00:00 |  | 2012-10-19 00:00:00 |  | NOLAN | 0.79 | 3.97
2012-10-19 00:00:00 |  | 2012-10-12 00:00:00 |  | NOLAN | 218.45 | 678.34
2012-10-19 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 387.68 | 1220.42
2012-10-22 00:00:00 |  | 2012-09-20 00:00:00 |  | VAUGHN | 770.1 | 2550.73
2012-10-22 00:00:00 |  | 2012-10-17 00:00:00 |  | VAUGHN | 42.96 | 149.91
2012-10-22 00:00:00 |  | 2012-10-19 00:00:00 |  | NOLAN | 120.16 | 382.88
2012-10-22 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 2180.77 | 9159.81
2012-10-22 00:00:00 |  | 2012-09-13 00:00:00 |  | VAUGHN | -160.75 | 0
2012-10-22 00:00:00 |  | 2012-10-22 00:00:00 |  | VAUGHN | 104.3 | 318.99
2012-10-22 00:00:00 |  | 2012-10-22 00:00:00 |  | NOLAN | 20.74 | 75.86
2012-10-23 00:00:00 |  | 2012-10-23 00:00:00 |  | ERNIE | 161.44 | 913.5
2012-10-23 00:00:00 |  | 2012-10-23 00:00:00 |  | VAUGHN | 22.91 | 73.88
2012-10-23 00:00:00 |  | 2012-10-19 00:00:00 |  | NOLAN | 50.01 | 117.12
2012-10-23 00:00:00 |  | 2012-10-23 00:00:00 |  | VAUGHN | 2016.95 | 4978.94
2012-10-23 00:00:00 |  | 2012-10-23 00:00:00 |  | VAUGHN | 837.24 | 1959.97
2012-10-24 00:00:00 |  | 2012-10-19 00:00:00 |  | NOLAN | 19.85 | 51.59
2012-10-24 00:00:00 |  | 2012-10-15 00:00:00 |  | VAUGHN | 1107.4 | 5294.13
2012-10-24 00:00:00 |  | 2012-10-18 00:00:00 |  | VAUGHN | 151.44 | 540.88
2012-10-24 00:00:00 |  | 2012-10-19 00:00:00 |  | VAUGHN | 142.8 | 412.27
2012-10-24 00:00:00 |  | 2012-10-23 00:00:00 |  | VAUGHN | 1790.32 | 4808.43
2012-10-24 00:00:00 |  | 2012-10-23 00:00:00 |  | VAUGHN | 1674.47 | 4126.03
2012-10-24 00:00:00 |  | 2012-10-24 00:00:00 |  |  | 20.68 | 53.53
2012-10-24 00:00:00 |  | 2012-10-24 00:00:00 |  | NOLAN | 4.46 | 12.92
2012-10-24 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 1.4 | 5.15
2012-10-24 00:00:00 |  | 2012-10-05 00:00:00 |  | NOLAN | 23.76 | 95.34
2012-10-24 00:00:00 |  | 2012-09-27 00:00:00 |  | NOLAN | 240.37 | 535.5
2012-10-25 00:00:00 |  | 2012-10-24 00:00:00 |  | NOLAN | 93.24 | 335.63
2012-10-25 00:00:00 |  | 2012-10-02 00:00:00 |  | NOLAN | 466.73 | 1386.47
2012-10-25 00:00:00 |  | 2012-10-11 00:00:00 |  | NOLAN | 309.61 | 902
2012-10-25 00:00:00 |  | 2012-10-25 00:00:00 |  | 3000 | -4.96 | 0
2012-10-25 00:00:00 |  | 2012-10-25 00:00:00 |  | VAUGHN | 0.56 | -26.34
2012-10-25 00:00:00 |  | 2012-10-17 00:00:00 |  | VAUGHN | 27.13 | 94.68
2012-10-25 00:00:00 |  | 2012-09-20 00:00:00 |  | VAUGHN | 743.1 | 2480.55
2012-10-25 00:00:00 |  | 2012-10-17 00:00:00 |  | VAUGHN | 3.66 | 9.56
2012-10-25 00:00:00 |  | 2012-10-24 00:00:00 |  | VAUGHN | -262.14 | 0
2012-10-25 00:00:00 |  | 2012-10-24 00:00:00 |  | NOLAN | 384.83 | 1203.88
2012-10-27 00:00:00 |  | 2012-10-27 00:00:00 |  |  | -1195 | -1395