Spreadsheet: 874040d1720607058-help-with-sub-total-formula-that-i-think-i-need-a-different-formula-instead-subtotal
Sheet: CostX

 |  |  |  | AliGW |  |  | TMS |  |  | JT | AliGW
 | Description | Quantity | UOM | Quantity |  |  | Description | Quantity |  | Quantity | Quantity
 | 1 | 43.95 | m2 |  |  |  |  | 43.95
 | 2 | 76.42 | m2 |  |  |  | 2 | 76.42
 | 3 | 77.32 | m2 |  |  |  | 3 | 77.32
 | 4 | 22.22 | m2 |  |  |  | 4 | 27.01
 | 4 | 4.79 | m2 |  |  |  | 5 | 20.89
 | 5 | 20.89 | m2 |  |  |  | 6 | 14.47
 | 6 | 11.39 | m2 |  |  |  | 7 | 14.43
 | 6 | 3.08 | m2 |  |  |  | 8 | 21.2
 | 7 | 11.37 | m2 |  |  |  | 9 | 23.41
 | 7 | 3.06 | m2 |  |  |  | 10 | 36.64
 | 8 | 21.2 | m2 |  |  |  | 11 | 23.53
 | 9 | 21.08 | m2 |  |  |  | 12 | 18.59
 | 9 | 2.33 | m2 |  |  |  | 13 | 35.53
 | 10 | 36.64 | m2 |  |  |  | 14 | 23.22
 | 11 | 13.52 | m2 |  |  |  | 15 | 26.48
 | 11 | 10.01 | m2 |  |  |  | 16 | 41.3
 | 12 | 4.71 | m2 |  |  |  | 17 | 20.18
 | 12 | 13.88 | m2 |  |  |  | 18 | 19.93
 | 13 | 35.53 | m2 |  |  |  | 19 | 42.03
 | 14 | 20.88 | m2 |  |  |  | 20 | 10.29
 | 14 | 2.34 | m2 |  |  |  | 22 | 13.14
 | 15 | 26.48 | m2 |  |  |  | 23 | 5.06
 | 16 | 41.3 | m2 |  |  |  | 24 | 27.32
 | 17 | 5.33 | m2 |  |  |  | 25 | 24.59
 | 17 | 14.85 | m2 |  |  |  | 26 | 43.97
 | 18 | 5.37 | m2 |  |  |  | 27 | 38.73
 | 18 | 14.56 | m2 |  |  |  | 28 | 29.06
 | 19 | 42.03 | m2 |  |  |  | 29 | 21.41
 | 20 | 6.54 | m2 |  |  |  | 30 | 35.94
 | 20 | 1.88 | m2 |  |  |  | 31 | 23.82
 | 20 | 1.87 | m2 |  |  |  | 32 | 19.11
 | 22 | 1.84 | m2 |  |  |  | 33 | 36.18
 | 22 | 1.86 | m2 |  |  |  | 34 | 21.27
 | 22 | 9.44 | m2 |  |  |  | 35 | 21.3
 | 23 | 5.06 | m2 |  |  |  | 36 | 21.08
 | 24 | 27.32 | m2 |  |  |  | 37 | 21.29
 | 25 | 15.03 | m2 |  |  |  | 38 | 26.99
 | 25 | 9.56 | m2 |  |  |  | 39 | 3.65
 | 26 | 43.97 | m2 |  |  |  | 40 | 26.68
 | 27 | 38.73 | m2 |  |  |  | 41 | 36.82
 | 28 | 29.06 | m2 |  |  |  | 42 | 37.45
 | 29 | 21.41 | m2 |  |  |  | 43 | 37.74
 | 30 | 35.94 | m2 |  |  |  | 44 | 37.64
 | 31 | 9.72 | m2 |  |  |  | 45 | 37.04
 | 31 | 14.1 | m2 |  |  |  | 46 | 35.87
 | 32 | 4.49 | m2 |  |  |  | 47 | 22.89
 | 32 | 14.62 | m2 |  |  |  | 48 | 14.9
 | 33 | 36.18 | m2 |  |  |  | 49 | 4.46
 | 34 | 21.27 | m2 |  |  |  | 50 | 11.41
 | 35 | 21.3 | m2 |  |  |  | 51 | 12.46
 | 36 | 21.08 | m2 |  |  |  | 52 | 23.54
 | 37 | 21.29 | m2 |  |  |  | 53 | 21.19
 | 38 | 23.46 | m2 |  |  |  | 54 | 23.56
 | 38 | 1.61 | m2 |  |  |  | 55 | 21.05
 | 38 | 1.92 | m2 |  |  |  | 56 | 35.32
 | 39 | 3.65 | m2 |  |  |  | 57 | 24.69
 | 40 | 23.19 | m2 |  |  |  | 58 | 17.36
 | 40 | 3.49 | m2 |  |  |  | 59 | 35.94
 | 41 | 36.82 | m2 |  |  |  | 60 | 32.81
 | 42 | 37.45 | m2 |  |  |  | 61 | 28.87
 | 43 | 37.74 | m2 |  |  |  | 62 | 41.22
 | 44 | 37.64 | m2 |  |  |  | 63 | 23.22
 | 45 | 37.04 | m2 |  |  |  | 64 | 26.43
 | 46 | 35.87 | m2 |  |  |  | 65 | 16.02
 | 47 | 19.36 | m2 |  |  |  | 66 | 5.07
 | 47 | 3.53 | m2 |  |  |  | 67 | 13.54
 | 48 | 2.73 | m2 |  |  |  | 68 | 28.95
 | 48 | 2.39 | m2 |  |  |  | 69 | 20.64
 | 48 | 9.78 | m2 |  |  |  | 70 | 46.97
 | 49 | 4.46 | m2 |  |  |  | 71 | 18.78
 | 50 | 3.05 | m2 |  |  |  | 72 | 18.95
 | 50 | 8.36 | m2 |  |  |  | 73 | 45.11
 | 51 | 9.37 | m2 |  |  |  | 74 | 17.96
 | 51 | 3.09 | m2 |  |  |  | 75 | 28.21
 | 52 | 2.34 | m2 |  |  |  | 76 | 13.46
 | 52 | 21.2 | m2 |  |  |  | 77 | 22.65
 | 53 | 21.19 | m2 |  |  |  | 79 | 28.45
 | 54 | 2.35 | m2 |  |  |  | 80 | 21.76
 | 54 | 21.21 | m2 |  |  |  | 81 | 21.26
 | 55 | 21.05 | m2 |  |  |  | 82 | 34.73
 | 56 | 35.32 | m2 |  |  |  | 83 | 30.02
 | 57 | 14.86 | m2 |  |  |  | 84 | 29.02
 | 57 | 9.83 | m2 |  |  |  | 85 | 16.85
 | 58 | 4.53 | m2 |  |  |  | 86 | 45.19
 | 58 | 12.83 | m2 |  |  |  | 87 | 10.39
 | 59 | 35.94 | m2 |  |  |  | 88 | 6.81
 | 60 | 32.81 | m2 |  |  |  | 89 | 14.69
 | 61 | 28.87 | m2 |  |  |  | 90 | 37.75
 | 62 | 41.22 | m2 |  |  |  | 91 | 27.55
 | 63 | 14.28 | m2 |  |  |  | 92 | 22.02
 | 63 | 8.94 | m2 |  |  |  | 93 | 43.92
 | 64 | 26.43 | m2 |  |  |  | 94 | 14.12
 | 65 | 10.95 | m2 |  |  |  | 95 | 6.16
 | 65 | 2.55 | m2 |  |  |  | 96 | 21.02
 | 65 | 2.52 | m2 |  |  |  | 97 | 29.43
 | 66 | 5.07 | m2 |  |  |  | 98 | 24.16
 | 67 | 1.27 | m2 |  |  |  | 99 | 21.5
 | 67 | 12.27 | m2 |  |  |  | 100 | 1.38
 | 68 | 28.95 | m2 |  |  |  | 101 | 27.04
 | 69 | 17.41 | m2 |  |  |  | 102 | 13.02
 | 69 | 3.23 | m2 |  |  |  | 103 | 40.09
 | 70 | 46.97 | m2 |  |  |  | 104 | 24.02
 | 71 | 1.84 | m2 |  |  |  | 105 | 29.68
 | 71 | 16.94 | m2 |  |  |  | 106 | 23.21
 | 72 | 17.1 | m2 |  |  |  | 107 | 34.95
 | 72 | 1.85 | m2 |  |  |  | 108 | 26.28
 | 73 | 45.11 | m2 |  |  |  | 109 | 26.57
 | 74 | 13.11 | m2 |  |  |  | 110 | 24.81
 | 74 | 4.85 | m2 |  |  |  | 111 | 17.71
 | 75 | 28.21 | m2 |  |  |  | 112 | 17.83
 | 76 | 12.22 | m2 |  |  |  | 113 | 12.09
 | 76 | 1.24 | m2 |  |  |  | 114 | 19.92
 | 77 | 1.69 | m2 |  |  |  | 115 | 6.13
 | 77 | 20.96 | m2 |  |  |  | 116 | 24.12
 | 79 | 28.45 | m2 |  |  |  | 117 | 42.77
 | 80 | 9.6 | m2 |  |  |  | 118 | 43.31
 | 80 | 12.16 | m2 |  |  |  | 119 | 51.24
 | 81 | 5.05 | m2 |  |  |  | 120 | 36.93
 | 81 | 16.21 | m2 |  |  |  | 121 | 65.94
 | 82 | 34.73 | m2 |  |  |  | 122 | 11.9
 | 83 | 30.02 | m2 |  |  |  | 123 | 43.44
 | 84 | 24.62 | m2 |  |  |  | 124 | 34.67
 | 84 | 4.4 | m2 |  |  |  | 125 | 43.27
 | 85 | 12.51 | m2 |  |  |  | 126 | 26.58
 | 85 | 4.34 | m2 |  |  |  | 127 | 14.24
 | 86 | 45.19 | m2
 | 87 | 3.7 | m2
 | 87 | 6.69 | m2
 | 88 | 1.04 | m2
 | 88 | 5.77 | m2
 | 89 | 13.01 | m2
 | 89 | 1.68 | m2
 | 90 | 2.25 | m2
 | 90 | 35.5 | m2
 | 91 | 27.55 | m2
 | 92 | 14.46 | m2
 | 92 | 7.56 | m2
 | 93 | 43.92 | m2
 | 94 | 1.89 | m2
 | 94 | 1.79 | m2
 | 94 | 10.44 | m2
 | 95 | 6.16 | m2
 | 96 | 21.02 | m2
 | 97 | 29.43 | m2
 | 98 | 24.16 | m2
 | 99 | 21.5 | m2
 | 100 | 1.38 | m2
 | 101 | 27.04 | m2
 | 102 | 1.38 | m2
 | 102 | 11.64 | m2
 | 103 | 40.09 | m2
 | 104 | 24.02 | m2
 | 105 | 29.68 | m2
 | 106 | 1.7 | m2
 | 106 | 21.51 | m2
 | 107 | 34.95 | m2
 | 108 | 26.28 | m2
 | 109 | 26.57 | m2
 | 110 | 22.98 | m2
 | 110 | 1.83 | m2
 | 111 | 6.25 | m2
 | 111 | 11.46 | m2
 | 112 | 6.28 | m2
 | 112 | 11.55 | m2
 | 113 | 2.58 | m2
 | 113 | 9.51 | m2
 | 114 | 1.38 | m2
 | 114 | 18.54 | m2
 | 115 | 6.13 | m2
 | 116 | 4.25 | m2
 | 116 | 19.87 | m2
 | 117 | 42.77 | m2
 | 118 | 43.31 | m2
 | 119 | 51.24 | m2
 | 120 | 36.93 | m2
 | 121 | 65.94 | m2
 | 122 | 5.42 | m2
 | 122 | 6.48 | m2
 | 123 | 43.44 | m2
 | 124 | 34.67 | m2
 | 125 | 43.27 | m2
 | 126 | 26.58 | m2
 | 127 | 14.24 | m2