Spreadsheet: 151946d1335193437-how-to-extract-large-and-small-amounts-from-vlookup-summary-help-042312
Sheet: Accounting List

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fee Summary |  |  |  |  |  |  | [NAME]
Print Date
# |  |  |  |  | Design | PM
6 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45828 | 3555 | 1500 | 500 | 0 | 1550 | 56945 | 45828 | 4012 | 0 | 0 | 0 | 0 |  |  |  | 0 |  | 0 |  |  |  | 55395
16 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51812 | 5500 | 1720 | 0 | 0 | 3420 | 62452 | 51812 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 |  | 0 |  |  |  | 59032
15 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69860 | 0 | 1720 | 0 | 0 | 5735 | 77315 | 51812 | 9188.072727272727 | 0 | 0 | 0 | 0 |  | 4265.890909090908 | 1312.581818181818 | 0 | 1093.818181818182 | 2187.636363636364 |  |  |  | 71580
49 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54868 | 2525 | 3440 | 0 | 0 | 7750 | 68583 | 51812 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 873.1428571428571 | 2182.857142857143 |  |  |  | 60833
2 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62380 | 5640 | 1720 | 0 | 0 | 6049 | 75789 | 51812 | 8679.42857142857 | 5264.571428571428 | 0 | 0 | 0 |  |  |  | 0 | 0 | 3984 |  |  |  | 69740
40 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48624 | 0 | 1750 | 0 | 0 | 4970 | 55344 | 45828 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 2796 |  |  |  | 50374
50 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58784 | 5840 | 1720 | 0 | 0 | 5549 | 71893 | 42180 | 6136.260869565217 | 0 | 0 | 3970.521739130435 |  | 3970.521739130435 |  | 0 | 0 | 721.9130434782609 | 1804.782608695652 |  |  |  | 66344
11 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57340 | 0 | 1720 | 0 | 0 | 4095 | 63155 | 51812 | 2163.130434782609 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 3364.869565217391 |  |  |  | 59060
27 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57556 | 2525 | 1750 | 0 | 0 | 1705 | 63536 | 51812 | 5744 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 61831
36 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65424 | 500 | 1500 | 0 | 0 | 2400 | 69824 | 51812 | 4804.235294117648 | 0 | 0 | 8807.764705882353 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 67424
31 |  |  |  |  | Machelle | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67448 | 0 | 1720 | 0 | 0 | 4770 | 73938 | 51812 | 6316.529801324504 | 3831.337748344371 | 0 | 0 | 0 |  | 2588.741721854305 |  | 0 | 0 | 2899.390728476821 |  |  |  | 69168
25 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59940 | 0 | 1720 |  | 0 | 4770 | 66430 | 51812 | 4501.661538461539 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 3501.292307692308 |  |  |  | 61660
22 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56700 | 0 | 1720 | 0 | 0 | 4885 | 63305 | 51812 | 3332.727272727273 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 1555.272727272727 |  |  |  | 58420
45 |  |  |  |  | Ty | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57844 | 0 | 1720 | 0 | 0 | 7370 | 66934 | 51812 | 0 | 0 | 0 | 0 | 0 |  | 3619.2 |  | 0 | 0 | 2412.8 |  |  |  | 59564
19 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59132 | 0 | 1720 | 0 | 0 | 4770 | 65622 | 51812 | 5286.666666666667 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 2033.333333333333 |  |  |  | 60852
29 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51812 | 0 | 1720 | 0 | 0 | 1270 | 54802 | 51812 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 53532
32 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51812 | 0 | 1720 | 0 | 0 | 2270 | 55802 | 51812 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 53532
56 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61248 | 5615 | 1720 |  | 0 | 7499 | 76082 | 57336 | 0 | 1630 | 0 | 0 | 0 |  |  |  | 0 | 0 | 2282 |  |  |  | 68583
30 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53684 | 0 | 1720 | 0 | 0 | 3270 | 58674 | 51812 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 1872 |  |  |  | 55404
34 |  |  |  |  | Ty | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60608 | 3189 | 1720 |  | 0 | 2395 | 67912 | 57336 | 0 | 0 | 0 | 1908.666666666667 | 0 |  |  |  | 1363.333333333333 | 0 | 0 |  |  |  | 65517
41 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54244 | 0 | 1720 |  | 0 | 2270 | 58234 | 51812 | 0 | 0 | 0 | 0 | 0 | 2432 |  |  | 0 | 0 | 0 |  |  |  | 55964
20 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68368 | 2940 | 1720 |  | 0 | 5045 | 78073 | 56080 | 4028.852459016393 | 2820.196721311475 | 0 | 0 | 0 |  | 1611.540983606557 |  | 0 | 1007.213114754098 | 2820.196721311475 |  |  |  | 73028
47 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59424 | 0 | 1720 |  | 0 | 4770 | 65914 | 56744 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 2680 |  |  |  | 61144
18 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64840 | 5890 | 1720 |  | 0 | 3499 | 75949 | 57336 | 0 | 5483.692307692308 | 2020.307692307692 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 72450
43 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65760 | 5615 | 1720 |  | 0 | 8249 | 81344 | 56080 | 0 | 4840 | 0 | 0 | 0 |  |  |  | 0 | 0 | 4840 |  |  |  | 73095
17 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63164 | 0 | 1720 |  | 0 | 4770 | 69654 | 51812 | 4790.752293577982 | 0 | 0 | 0 | 0 |  | 3645.137614678899 |  | 0 | 0 | 2916.110091743119 |  |  |  | 64884
38 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62164 | 2200 | 1720 |  | 0 | 4575 | 70659 | 55128 | 1887.707317073171 | 0 | 0 | 0 |  | 2745.756097560976 |  |  | 0 | 0 | 2402.536585365854 |  |  |  | 66084
1 |  |  |  |  | Ty | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56304 | 5390 | 1720 |  | 0 | 4354 | 67768 | 55128 | 0 | 0 | 0 | 0 | 0 | 504 |  |  | 672 | 0 | 0 |  |  |  | 63414
9 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59368 | 2525 | 1720 |  | 0 | 3075 | 66688 | 57336 | 0 | 0 | 0 | 0 | 0 |  | 451.5555555555555 |  | 0 | 0 | 1580.444444444445 |  |  |  | 63613
58 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55344 | 0 | 1720 |  | 0 | 2270 | 59334 | 55344 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 57064
44 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56116 | 4840 | 1720 |  | 500 | 3670 | 66846 | 55344 | 0 | 0 | 0 | 0 |  |  | 154.4 |  | 617.6 | 0 | 0 |  |  |  | 63176
52 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55344 | 0 | 1720 |  | 0 | 2270 | 59334 | 55344 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 57064
53 |  |  |  |  | Machelle | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59760 | 0 | 1720 |  | 0 | 3770 | 65250 | 55344 | 0 | 0 | 0 | 0 | 0 | 1943.04 |  |  | 0 | 0 | 2472.96 |  |  |  | 61480
55 |  |  |  |  | Ty | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56528 | 5390 | 1720 |  | 500 | 3220 | 67358 | 55344 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1184 | 0 | 0 |  |  |  | 64138
37 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66228 | 5790 | 1720 |  | 0 | 4920 | 78658 | 55128 | 3929.203539823009 | 2357.522123893805 | 0 | 0 | 0 |  | 2062.83185840708 |  | 0 | 0 | 2750.442477876106 |  |  |  | 73738
57 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55344 | 0 | 1720 |  | 0 | 1270 | 58334 | 55344 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  | 57064
35 |  |  |  |  | Ty | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58688 | 0 | 1720 |  | 0 | 2270 | 62678 | 55344 | 0 | 0 | 0 |  | 3344 |  |  |  | 0 | 0 | 0 |  |  |  | 60408
23 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63212 | 5340 | 1720 |  | 0 | 5020 | 75292 | 55344 | 3420.869565217391 | 2052.521739130435 | 0 | 0 |  |  |  |  | 0 | 0 | 2394.608695652174 |  |  |  | 70272
46 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57768 | 0 | 1720 |  | 0 | 4270 | 63758 | 55344 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 2424 |  |  |  | 59488
3 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63656 | 5390 | 1720 |  | 0 | 3520 | 74286 | 55344 | 4749.714285714285 | 3166.47619047619 | 0 | 0 |  |  | 395.8095238095238 |  | 0 | 0 | 0 |  |  |  | 70766
5 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59904 | 5390 | 1720 |  | 0 | 3520 | 70534 | 55344 | 0 | 4560 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  | 67014
8 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60524 | 5390 | 1720 |  | 500 | 5020 | 73154 | 55344 | 0 | 2072 | 0 | 0 |  |  |  |  | 690.6666666666666 | 0 | 2417.333333333333 |  |  |  | 68134
10 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61144 | 5140 | 1720 |  | 0 | 5680 | 73684 | 55344 | 3411.764705882353 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 2388.235294117647 |  |  |  | 68004
12 |  |  |  |  | Lon | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57768 | 0 | 1720 |  | 0 | 3770 | 63258 | 55344 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 2424 |  |  |  | 59488
13 |  |  |  |  | [NAME] | [NAME]
42 |  |  |  |  | Machelle | [NAME]
51 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65376 | 5140 | 1720 |  | 500 | 5540 | 78276 | 55344 | 4012.8 | 2407.68 | 0 | 0 |  |  |  |  | 802.5600000000001 | 0 | 2808.96 |  |  |  | 72736
14 |  |  |  |  | [NAME] | [NAME]
26 |  |  |  |  | Lon | [NAME]
28 |  |  |  |  | [NAME] | [NAME]
48 |  |  |  |  | [NAME] | [NAME]
39 |  |  |  |  | Zack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56960 | 0 | 1720 |  | 0 | 2270 | 60950 | 55344 | 0 | 0 | 0 | 0 |  |  | 1616 |  | 0 | 0 | 0 |  |  |  | 58680
7 |  |  |  |  | Lon | [NAME]
21 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58800 | 0 | 1720 |  | 500 | 3770 | 64790 | 55344 | 0 | 0 | 0 | 0 |  |  | 181.8947368421053 |  | 727.578947368421 | 0 | 2546.526315789474 |  |  |  | 61020
54 |  |  |  |  | [NAME] | [NAME]
33 |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54940 | 0 | 1720 |  | 0 | 4770 | 61430 | 54940 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  | 56660
24 |  |  |  |  | Ty | [NAME]
4 |  |  |  |  | Zack
 |  |  |  | Average Fee
 |  |  |  | Low Fee
 |  |  |  | High Fee