Spreadsheet: 145467d1331599283-nested-sumif-range-problem-op-tghcogo-nested-sumif-range-problem
Sheet: Purchases

 |  |  |  |  |  |  |  | Payments Made to Creditors |  |  | Direct Materials | Sub Contractors | Other Direct Costs
Purchase Ledger No | Month | Purchase Date | Supplier | Job No | Expense Code | Total Purchase Value | How Paid | Actual Amount Paid | Not yet paid | Days Outstanding | S | C | O
 |  |  |  | 134
 |  |  |  | 137 |  |  |  |  |  |  | 28.93
 |  |  |  | 137 |  |  |  |  |  |  | 41.64
 |  |  |  | 137 |  |  |  |  |  |  | 11.12
 |  |  |  | 137 |  |  |  |  |  |  | 30.6 | 200
 |  |  |  | 135 |  |  |  |  |  |  | 63.1
 |  |  |  | 140 |  |  |  |  |  |  | 60.98
 |  |  |  | 140 |  |  |  |  |  |  | 5.98
 |  |  |  | 140 |  |  |  |  |  |  | 2.98
 |  |  |  | 140 |  |  |  |  |  |  | 44.84
 |  |  |  | 144 |  |  |  |  |  |  | 2.56
 |  |  |  | 144 |  |  |  |  |  |  | 10.17
 |  |  |  | 144 |  |  |  |  |  |  | 3.46
 |  |  |  | 153 |  |  |  |  |  |  | 14.4
 |  |  |  | 151 |  |  |  |  |  |  | 123
 |  |  |  | 153 |  |  |  |  |  |  | 38.89
 |  |  |  | 153 |  |  |  |  |  |  | 13.5
 |  |  |  | 153
 |  |  |  | 151 |  |  |  |  |  |  | 9.34
 |  |  |  | 153 |  |  |  |  |  |  | 9.59
 |  |  |  | 148 |  |  |  |  |  |  | 19.98
 |  |  |  | 153 |  |  |  |  |  |  | 14.27
 |  |  |  | 153 |  |  |  |  |  |  | 3.29
 |  |  |  | 153
 |  |  |  | 153 |  |  |  |  |  |  | 38.89
 |  |  |  | 153 |  |  |  |  |  |  | 4.79
 |  |  |  | 153 |  |  |  |  |  |  | 6.7
 |  |  |  | 153 |  |  |  |  |  |  | 9.58
 |  |  |  | 153 |  |  |  |  |  |  | 8.68
 |  |  |  | 153 |  |  |  |  |  |  | 54.84
 |  |  |  | 153 |  |  |  |  |  |  | 6.79
 |  |  |  | 155 |  |  |  |  |  |  | 8.34
 |  |  |  | 148 |  |  |  |  |  |  | 20.83
 |  |  |  | 153 |  |  |  |  |  |  | 165.85
 |  |  |  |  |  |  |  |  |  |  | 28.73
 |  |  |  |  |  |  |  |  |  |  | -13.18
 |  |  |  | 154 |  |  |  |  |  |  | 14.11
 |  |  |  | 154 |  |  |  |  |  |  | 17.58
 |  |  |  | 150 |  |  |  |  |  |  | 37.68
 |  |  |  | 151 |  |  |  |  |  |  | 123
 |  |  |  | 153 |  |  |  |  |  |  | -33.01
 |  |  |  | 152 |  |  |  |  |  |  | 14.64
 |  |  |  | 153 |  |  |  |  |  |  | 19.98
 |  |  |  | 155 |  |  |  |  |  |  | 24.97
 |  |  |  | 155 |  |  |  |  |  |  | 1.93
 |  |  |  | 155 |  |  |  |  |  |  | 22.52
 |  |  |  | 155 |  |  |  |  |  |  | -4.76
 |  |  |  | 155 |  |  |  |  |  |  | 54.23
 |  |  |  | 155 |  |  |  |  |  |  | 17.08
 |  |  |  | 153 |  |  |  |  |  |  | 2.58
 |  |  |  | 153 |  |  |  |  |  |  | 6.59
 |  |  |  | 153 |  |  |  |  |  |  | 10.25
 |  |  |  | 153 |  |  |  |  |  |  | -2.75
 |  |  |  | 156 |  |  |  |  |  |  | 47.95
 |  |  |  | 150
 |  |  |  | 155 |  |  |  |  |  |  | 1.93
 |  |  |  | 153 |  |  |  |  |  |  | 21.56
 |  |  |  | 156 |  |  |  |  |  |  | 14.99
 |  |  |  | 153 |  |  |  |  |  |  | 50.82
 |  |  |  | 153
 |  |  |  | 153 |  |  |  |  |  |  | 17.49
 |  |  |  | 161 |  |  |  |  |  |  | 9.87
 |  |  |  | 157 |  |  |  |  |  |  | 3.97
 |  |  |  | 157 |  |  |  |  |  |  | 5.08
 |  |  |  | 156 |  |  |  |  |  |  | 92.48
 |  |  |  | 153 |  |  |  |  |  |  | 55.67
 |  |  |  | 153 |  |  |  |  |  |  | -38.8
 |  |  |  | 161
 |  |  |  | 153 |  |  |  |  |  |  | 6.32
 |  |  |  | 155 |  |  |  |  |  |  | 26.5
 |  |  |  | 149 |  |  |  |  |  |  | 41.72
 |  |  |  | 141 |  |  |  |  |  |  | 34.28
 |  |  |  | 135 |  |  |  |  |  |  | 30.07
 |  |  |  | 140 |  |  |  |  |  |  | 4.8
 |  |  |  | 159 |  |  |  |  |  |  | 29.48
 |  |  |  | 159 |  |  |  |  |  |  |  | 750