Spreadsheet: 120507d1315337752-sum-mutliple-criteria-using-the-mid-function-spreadsheet-example
Sheet: Table

Cost Code | Disc | Hours | [NAME]
20195001 | CD | 31 | 4789.28
20195001 | CD | 31 | 4789.28
20195001 | CD | 31 | 4789.28
20195001 | CD | 31 | 4789.28
20195002 | CD | 40 | 5194.75
20195002 | CD | 9 | 1168.82
20195002 | CD | 23 | 2986.98
20195002 | CD | 8 | 1038.95
20195004 | CD | -40 | -1740.1
20195004 | CD | 0 | -65.25
20195004 | CD | -40 | -1740.1
20195004 | CD | -3 | -130.51
20195005 | CD | 40 | 5194.75
20195006 | CD | 39 | 1696.59
20195006 | CD | 40 | 1740.1
20195006 | CD | 40 | 1740.1
20195006 | CD | 3 | 130.51
20195006 | CD | 40 | 1740.1
20195006 | CD | 39 | 1696.59
20195006 | CD | 40 | 1740.1
20195006 | CD | 0 | 65.25
20208000 | CE | 4 | 601.19
20208000 | CE | 8 | 1202.38
20210600 | CE | 4 | 338.53
20210600 | CE | 0.5 | 42.32
20210600 | CE | 7.5 | 634.75
20211000 | CE | 9 | 1368.27
20211000 | CE | 7 | 592.44
20211000 | CE | 3 | 253.9
20211102 | CE | 3 | 253.9
20213000 | CE | 3 | 456.09
20213000 | CE | 5 | 760.15
20213000 | CE | 9.5 | 804.02
20213000 | CE | 8 | 1322.54
20213001 | CE | 2 | 169.27
20213200 | CE | 4 | 338.53
20288821 | CE | 11 | 1672.33
20293501 | CE | 2 | 304.06
20293501 | CE | 2 | 304.06
20293501 | CE | 0.5 | 42.32
20293501 | CE | 1 | 84.63
20293501 | CE | 0.5 | 42.32
20293501 | CE | 0.5 | 42.32
20293502 | CE | 4 | 608.12
20293502 | CE | 2 | 304.06
20293503 | CE | 5 | 760.15
20293503 | CE | 4 | 608.12
20293503 | CE | 31 | 4712.94
20293600 | CE | 6 | 912.18
20294002 | CE | 14 | 2128.43
20294500 | CE | 2 | 169.27
20294600 | CE | 2.5 | 211.58
20294600 | CE | 2 | 169.27
20294600 | CE | 6.5 | 550.12
20295002 | CE | 10 | 1502.98
20295002 | CE | 25 | 3757.44
20295003 | CE | 11 | 1653.27
20295003 | CE | 9 | 1352.68
20295005 | CE | 5 | 423.17
20295005 | CE | 13 | 1953.87
20295006 | CE | 19 | 2888.58
20295006 | CE | 10 | 846.34
20295006 | CE | 6.5 | 550.12
20295006 | CE | 8.5 | 719.39
20295006 | CE | 27 | 4058.04
20295006 | CE | 13 | 1953.87
20295006 | CE | 40 | 6011.9
20295007 | CE | 10 | 846.34
20295007 | CE | 16 | 1354.14
20295008 | CE | 5 | 423.17
20295008 | CE | 2 | 169.27
20295009 | CE | 7 | 1064.21
20295009 | CE | 4 | 608.12
20295009 | CE | 12 | 1824.36
20295009 | CE | 7 | 1064.21
20295009 | CE | 4 | 608.12
20299000 | CE | 1 | 173.01
20299000 | CE | 1 | 173.01
20299000 | CE | 1 | 173.01
20393501 | ED | 1 | 143.55
20393501 | ED | 11 | 1579.04
20393501 | ED | 30 | 4306.46
20393501 | ED | 7 | 1004.84
20393502 | ED | 2 | 287.1
20393502 | ED | 2 | 287.1
20393502 | ED | 1 | 143.55
20393503 | ED | 8 | 1148.39
20393503 | ED | 5 | 717.74
20393603 | ED | 2 | 287.1
20395701 | ED | 27 | 2366.37
20395701 | ED | 40 | 3505.73
20395701 | ED | 31 | 2716.94
20395701 | ED | 35 | 3067.51
20395901 | ED | 9 | 1291.94
20395901 | ED | 14 | 2009.68
20395901 | ED | 11 | 1579.04
20396001 | ED | 10 | 1435.49
20396001 | ED | 1 | 143.55
20396001 | ED | 11 | 1579.04
20398200 | ED | 3 | 430.65
20398200 | ED | 7 | 1004.84
20398200 | ED | 10 | 1435.49
20439901 | EE | 1 | 143.28
20439903 | EE | 2 | 286.55
20439903 | EE | 2 | 286.55
20439903 | EE | 2 | 286.55
20439904 | EE | 1 | 143.28
20493501 | EE | 5 | 716.38
20493501 | EE | 2 | 286.55
20493502 | EE | 1 | 143.28
20493502 | EE | 5 | 716.38
20493502 | EE | 6 | 859.65
20493602 | EE | 2 | 254.45
20493602 | EE | 3 | 429.83
20493602 | EE | 7 | 1002.93
20496001 | EE | 1 | 127.22
20593200 | ID | 1 | 138.53
20593200 | ID | 21 | 2909.19
20593400 | ID | 5 | 692.66
20593400 | ID | 4 | 554.13
20593400 | ID | 1.5 | 207.8
20593501 | ID | 0.5 | 69.27
20593501 | ID | 1 | 138.53
20593501 | ID | 0.5 | 69.27
20593502 | ID | 0.5 | 69.27
20593502 | ID | 1 | 138.53
20593601 | ID | 3.5 | 484.86
20593602 | ID | 0.5 | 69.27
20593602 | ID | 1 | 138.53
20595801 | ID | 33 | 3223.28
20595801 | ID | 35 | 3418.63
20595801 | ID | 30.5 | 4225.25
20595801 | ID | 32.5 | 4502.32
20595801 | ID | 30 | 4155.98
20595801 | ID | 13 | 1800.93
20596200 | ID | 2 | 277.07
20596200 | ID | 4 | 554.13
20596200 | ID | 1 | 138.53
20597000 | ID | 2 | 277.07
20642000 | IE | 1 | 95.85
20642600 | IE | 1 | 143.46
20643200 | IE | 1 | 143.46
20643400 | IE | 7.5 | 718.88
20643400 | IE | 3.5 | 335.48
20643400 | IE | 3 | 287.55
20643400 | IE | 1 | 143.46
20643400 | IE | 1 | 143.46
20644200 | IE | 2 | 191.7
20644200 | IE | 4 | 383.4
20644200 | IE | 7.5 | 718.88
20646100 | IE | 1 | 143.46
20646200 | IE | 7 | 1004.2
20646200 | IE | 1 | 143.46
20646600 | IE | 2 | 191.7
20648200 | IE | 2 | 191.7
20648200 | IE | 9 | 862.66
20648300 | IE | 3.5 | 335.48
20648300 | IE | 5 | 479.26
20648300 | IE | 6 | 575.11
20648300 | IE | 2.5 | 239.63
20649900 | IE | 1 | 143.46
20688810 | IE | 1 | 95.85
20688810 | IE | 2 | 191.7
20690000 | IE | 2 | 286.92
20693200 | IE | 6 | 980.58
20693200 | IE | 4 | 653.72
20693200 | IE | 4 | 573.83
20693200 | IE | 8 | 1147.66
20693200 | IE | 7 | 1004.2
20693200 | IE | 7 | 1004.2
20693400 | IE | 5 | 817.15
20693400 | IE | 22 | 3156.07
20693400 | IE | 11 | 1578.03
20693501 | IE | 23 | 3299.52
20693501 | IE | 7 | 1004.2
20693501 | IE | 5 | 717.29
20693501 | IE | 4 | 573.83
20693501 | IE | 4 | 573.83
20693501 | IE | 2 | 286.92
20693502 | IE | 6 | 860.75
20693502 | IE | 1 | 143.46
20693502 | IE | 7 | 1004.2
20693502 | IE | 7 | 1004.2
20693602 | IE | 4 | 573.83
20693602 | IE | 2 | 286.92
20695801 | IE | 9 | 1291.12
20695801 | IE | 4 | 573.83
20695802 | IE | 1 | 97.68
20695802 | IE | 5 | 488.38
20695802 | IE | 1 | 143.46
20695802 | IE | 1 | 143.46
20696300 | IE | 17 | 2732.6
20696300 | IE | 17 | 2732.6
20696300 | IE | 9 | 1470.87
20696300 | IE | 5 | 817.15
20696300 | IE | 5 | 817.15
20696300 | IE | 9 | 1470.87
20788823 | MD | 9 | 499.87
20793401 | MD | 3 | 486.19
20793401 | MD | 8 | 1296.5
20793401 | MD | 7 | 1134.44
20793401 | MD | 2.5 | 219.56
20793401 | MD | 15 | 1317.38
20793401 | MD | 9 | 790.43
20793401 | MD | 25 | 2195.64
20793402 | MD | 6 | 972.37
20793402 | MD | 3 | 486.19
20793402 | MD | 2.5 | 219.56
20793402 | MD | 17 | 1493.04
20793402 | MD | 8 | 702.6
20793501 | MD | 6 | 972.37
20793501 | MD | 12 | 1944.75
20793501 | MD | 15 | 2430.94
20793501 | MD | 4 | 648.25
20793501 | MD | 5 | 810.31
20793501 | MD | 14 | 2268.87
20793502 | MD | 2 | 324.12
20793602 | MD | 2 | 253.35
20793602 | MD | 4 | 506.71
20793608 | MD | 3 | 263.48
20793608 | MD | 1 | 87.83
20793608 | MD | 6 | 526.95
20793608 | MD | 11 | 1580.04
20793608 | MD | 13 | 1867.32
20793608 | MD | 2 | 287.28
20793608 | MD | 11.5 | 1651.86
20793610 | MD | 3 | 263.48
20793610 | MD | 1 | 87.83
20793610 | MD | 3 | 263.48
20793613 | MD | 7 | 388.79
20793615 | MD | 9 | 1458.56
20794002 | MD | 10 | 1620.62
20794002 | MD | 3 | 486.19
20795501 | MD | 4 | 648.25
20795505 | MD | 4 | 648.25
20795505 | MD | 44 | 5599.84
20795505 | MD | 10 | 1436.4
20795507 | MD | 14 | 1229.56
20795507 | MD | 15 | 1317.38
20795507 | MD | 33 | 2898.24
20795507 | MD | 2 | 175.65
20795507 | MD | 1 | 51.25
20795509 | MD | 40 | 2221.63
20795509 | MD | 40 | 2221.63
20795509 | MD | 24 | 1332.98
20795509 | MD | 33 | 1832.85
20795512 | MD | 4 | 574.56
20795600 | MD | 44 | 4791.4
20808000 | ME | 2 | 264.84
20808000 | ME | 2 | 264.84
20811000 | ME | 2 | 264.84
20811000 | ME | 1 | 132.42
20811102 | ME | 1 | 132.42
20811102 | ME | 10 | 1676.26
20811102 | ME | 8 | 1341
20811200 | ME | 1 | 132.42
20811200 | ME | 10 | 1676.26
20811400 | ME | 1 | 132.42
20811400 | ME | 2 | 153.22
20811400 | ME | 3 | 229.82
20811600 | ME | 4 | 306.43
20820000 | ME | 1 | 132.42
20820000 | ME | 1 | 132.42
20820000 | ME | 1 | 132.42
20820000 | ME | 5 | 383.04
20820400 | ME | 5 | 383.04
20820400 | ME | 2 | 153.22
20820400 | ME | 4 | 306.43
20821000 | ME | 5 | 662.11
20821000 | ME | 2 | 264.84
20821000 | ME | 4 | 529.69
20821000 | ME | 5 | 383.04
20821000 | ME | 8 | 612.86
20821000 | ME | 7 | 536.26
20821000 | ME | 3 | 229.82
20821200 | ME | 1 | 132.42
20821200 | ME | 3 | 502.88
20821200 | ME | 3 | 229.82
20821400 | ME | 1 | 132.42
20821400 | ME | 2 | 264.84
20821400 | ME | 4 | 670.5
20821400 | ME | 4 | 306.43
20821400 | ME | 6 | 459.65
20821800 | ME | 4 | 306.43
20821800 | ME | 4 | 306.43
20821800 | ME | 3 | 229.82
20821801 | ME | 1 | 132.42
20821801 | ME | 1 | 132.42
20821801 | ME | 3 | 229.82
20821801 | ME | 1 | 76.61
20821801 | ME | 3 | 229.82
20822000 | ME | 1 | 132.42
20822000 | ME | 8 | 612.86
20822000 | ME | 12 | 919.3
20822000 | ME | 7 | 536.26
20822001 | ME | 2 | 264.84
20822001 | ME | 1 | 132.42
20822001 | ME | 1 | 132.42
20822001 | ME | 3 | 229.82
20822001 | ME | 7 | 536.26
20822002 | ME | 2 | 264.84
20822002 | ME | 1 | 132.42
20822002 | ME | 2 | 153.22
20822003 | ME | 1 | 132.42
20822003 | ME | 2 | 264.84
20822003 | ME | 2 | 153.22
20822003 | ME | 2 | 153.22
20822004 | ME | 1 | 132.42
20822004 | ME | 2 | 153.22
20822004 | ME | 3 | 229.82
20823200 | ME | 1 | 132.42
20823200 | ME | 2 | 264.84
20823200 | ME | 1 | 132.42
20823200 | ME | 11 | 1843.88
20823200 | ME | 13 | 2179.13
20824600 | ME | 2 | 264.84
20824600 | ME | 8 | 1059.38
20824600 | ME | 1 | 132.42
20824600 | ME | 1 | 167.63
20824600 | ME | 1 | 76.61
20826200 | ME | 2 | 264.84
20826200 | ME | 0.5 | 83.81
20826400 | ME | 0.5 | 83.81
20826400 | ME | 1 | 76.61
20829900 | ME | 1 | 132.42
20829900 | ME | 1 | 132.42
20829900 | ME | 2 | 264.84
20829900 | ME | 3 | 502.88
20846100 | ME | 1 | 132.42
20846100 | ME | 1 | 132.42
20846100 | ME | 6 | 1005.75
20846100 | ME | 8 | 1341
20846200 | ME | 1 | 132.42
20846300 | ME | 1 | 132.42
20846600 | ME | 1 | 132.42
20893400 | ME | 1 | 132.42
20893400 | ME | 1 | 132.42
20893400 | ME | 5 | 662.11
20893501 | ME | 3 | 397.27
20893501 | ME | 4 | 529.69
20893501 | ME | 3 | 397.27
20893501 | ME | 5 | 662.11
20893501 | ME | 2 | 335.25
20893502 | ME | 2 | 264.84
20893502 | ME | 1 | 132.42
20893502 | ME | 2 | 264.84
20893503 | ME | 2 | 264.84
20893503 | ME | 2 | 264.84
20893503 | ME | 4 | 529.69
20895501 | ME | 2 | 264.84
20895501 | ME | 1 | 132.42
20895502 | ME | 1 | 132.42
20895503 | ME | 1 | 132.42
20895503 | ME | 1 | 132.42
20897300 | ME | 1 | 132.42
20988810 | ME | 2 | 253.35
21071010 | PM | 20 | 5035.93
21071010 | PM | 20.5 | 5161.83
21071010 | PM | 21 | 5287.73
21071010 | PM | 27 | 6798.5
21071012 | PM | 19 | 3993.33
21071012 | PM | 20 | 4203.52
21071012 | PM | 31 | 6515.44
21071012 | PM | 25 | 5254.4
21071014 | PM | 4 | 290.27
21071014 | PM | 6 | 435.41
21071014 | PM | 4 | 290.27
21071014 | PM | 5 | 362.84
21071210 | EM | 40 | 7239.84
21071210 | EM | 40 | 7239.84
21071210 | EM | 40 | 7239.84
21071212 | EM | 38 | 2259.57
21071212 | EM | 34.5 | 2051.45
21071212 | EM | 40 | 2378.5
21071212 | EM | 40 | 2378.5
21071212 | EM | 2 | 114
21071214 | EM | 4 | 835.44
21071214 | EM | 2 | 263.77
21071216 | EM | 32 | 1824
21071216 | EM | 31 | 1767
21071216 | EM | 26.25 | 1496.25
21071216 | EM | 40 | 2280
21071220 | EM | 10 | 1435.49
21071220 | EM | 5 | 717.74
21071220 | EM | 17 | 2153.51
21071220 | EM | 29.5 | 3736.97
21071220 | EM | 15 | 1900.15
21071220 | EM | 29 | 3673.63
21071410 | PR | 37 | 4737.66
21071410 | PR | 6 | 768.27
21071410 | PR | 7 | 896.31
21071410 | PR | 35.5 | 4545.59
21071410 | PR | 33 | 4225.48
21071410 | PR | 15.5 | 1984.69
21071412 | PR | 8 | 1275.34
21071412 | PR | 6 | 956.51
21071412 | PR | 16 | 2550.68
21071412 | PR | 13 | 2072.43
21071412 | PR | 22 | 3507.19
21071412 | PR | 9 | 1434.76
21071412 | PR | 3 | 478.25
21071412 | PR | 16 | 2550.68
21071414 | PR | 8 | 751.49
21071414 | PR | 4 | 375.74
21071414 | PR | 7 | 657.55
21071414 | PR | 20 | 1878.72
21071414 | PR | 3 | 281.81
21071414 | PR | 9 | 876.61
21071414 | PR | 5 | 487.01
21071414 | PR | 5 | 487.01
21071414 | PR | 22 | 2142.84
21071414 | PR | 5 | 487.01
21071416 | PR | 3 | 292.2
21071416 | PR | 6 | 584.41
21071416 | PR | 8 | 525.31
21071416 | PR | 6 | 393.98
21071416 | PR | 9 | 590.98
21071416 | PR | 9 | 590.98
21071610 | PC | 27 | 4072.03
21071610 | PC | 33 | 4976.92
21071610 | PC | 27 | 4072.03
21071610 | PC | 27 | 4072.03
21071612 | PC | 4 | 309.94
21071612 | PC | 26 | 2014.65
21071612 | PC | 36 | 2789.53
21071612 | PC | 6 | 464.91
21071612 | PC | 5 | 387.44
21071612 | PC | 29 | 2247.12
21071612 | PC | 37 | 2867.01
21071614 | PC | 31 | 1973.68
21071614 | PC | 26 | 1655.35
21071614 | PC | 25 | 1591.67
21071614 | PC | 10 | 636.67
21071614 | PC | 5 | 318.33
21071614 | PC | 33 | 2101.02
21071614 | PC | 3 | 191
21071614 | PC | 2 | 127.34
21071620 | EST | 1.5 | 305.75
21071710 | AC | 12.5 | 1459.59
21071710 | AC | 12 | 1401.22
21071710 | AC | 12.5 | 1459.59
21071712 | AC | 4 | 225.45
21071712 | AC | 0.25 | 14.09
21071712 | AC | 5 | 281.81
21071712 | AC | 0 | 7.05
21071712 | AC | 1.5 | 96.19
21071712 | AC | 6.5 | 416.81
21071712 | AC | 7.5 | 480.94
21072410 | QA | 6 | 739.7
21072410 | QA | 5 | 616.42
21072410 | QA | 2 | 246.56
21072414 | QA | 0.5 | 37.48
21072414 | QA | 4 | 299.87
21072414 | QA | 1 | 77.54
21072414 | QA | 1 | 77.54