Spreadsheet: 149460d1333981495-changing-sum-if-left-formula-cf
Sheet: House

 | item |  |  |  |  |  |  | Balance |  |  | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00 | 2012-05-04 00:00:00
 | 8LA |  |  |  |  |  |  | 11060.65 |  |  | 0 | 11060.65 | 0 | 0 | 0
 | 9EL |  |  |  |  |  |  | 22365 |  |  | 0 | 0 | 22365 | 0 | 0
 | 9EL |  |  |  |  |  |  | 20109.6 |  |  | 0 | 0 | 20109.6 | 0 | 0
 | 9EL |  |  |  |  |  |  | 15331.68 |  |  | 0 | 0 | 15331.68 | 0 | 0
 | 9EL |  |  |  |  |  |  | 11566.8 |  |  | 0 | 0 | 11566.8 | 0 | 0
 | 9EL |  |  |  |  |  |  | 9240 |  |  | 0 | 0 | 9240 | 0 | 0
 | 9EL |  |  |  |  |  |  | 8820 |  |  | 0 | 0 | 8820 | 0 | 0
 | 9EL |  |  |  |  |  |  | 7560 |  |  | 0 | 0 | 7560 | 0 | 0
 | 9EL |  |  |  |  |  |  | 7350 |  |  | 0 | 0 | 7350 | 0 | 0
 | 9EL |  |  |  |  |  |  | 5544 |  |  | 0 | 0 | 5544 | 0 | 0
 | 33C |  |  |  |  |  |  | 35505 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | 19089 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | 28628.1 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | 4082.4 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | 999 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | 2235.6 |  |  | 0 | 0 | 0 | 0 | 0
 | 33C |  |  |  |  |  |  | -4185 |  |  | 0 | 0 | 0 | 0 | 0
 | 33E |  |  |  |  |  |  | 0.66 |  |  | 0 | 0 | 0 | 0 | 0
 | 33E |  |  |  |  |  |  | -202.81 |  |  | 0 | 0 | 0 | 0 | 0
 | 33E |  |  |  |  |  |  | 48.94 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1542 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1542 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1542 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1397 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1447 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | 1542 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | -20.95 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | -178 |  |  | 0 | 0 | 0 | 0 | 0
 | 33T |  |  |  |  |  |  | -27.5 |  |  | 0 | 0 | 0 | 0 | 0
 | 3BU |  |  |  |  |  |  | 8970 |  |  | 0 | 0 | 0 | 8970 | 0
 | 3BU |  |  |  |  |  |  | 7752 |  |  | 0 | 0 | 0 | 7752 | 0
 | 3BU |  |  |  |  |  |  | 1783.6 |  |  | 0 | 0 | 0 | 1783.6 | 0
 | 3BU |  |  |  |  |  |  | 1209.6 |  |  | 0 | 0 | 0 | 1209.6 | 0
 | 3BU |  |  |  |  |  |  | 1148 |  |  | 0 | 0 | 0 | 1148 | 0
 | 3BU |  |  |  |  |  |  | 1544.4 |  |  | 0 | 0 | 0 | 1544.4 | 0
 | 3BU |  |  |  |  |  |  | 924 |  |  | 0 | 0 | 0 | 924 | 0
 | 3BU |  |  |  |  |  |  | 5637.4 |  |  | 0 | 0 | 0 | 5637.4 | 0
 | 3BU |  |  |  |  |  |  | 13483.6 |  |  | 0 | 0 | 0 | 13483.6 | 0
 | 3BU |  |  |  |  |  |  | 8195.04 |  |  | 0 | 0 | 0 | 0 | 8195.04
 | 3BU |  |  |  |  |  |  | 190.8 |  |  | 0 | 0 | 0 | 0 | 190.8
 | 3BU |  |  |  |  |  |  | 9197.62 |  |  | 0 | 0 | 0 | 0 | 9197.62
 | 3BU |  |  |  |  |  |  | 40456.39 |  |  | 0 | 0 | 0 | 0 | 40456.39
 | 3BU |  |  |  |  |  |  | 7124.74 |  |  | 0 | 0 | 0 | 0 | 7124.74
 | 3BU |  |  |  |  |  |  | 7807.6 |  |  | 0 | 0 | 0 | 0 | 7807.6
 | 3BU |  |  |  |  |  |  | 4685.4 |  |  | 0 | 0 | 0 | 0 | 4685.4
 | 3BU |  |  |  |  |  |  | 1696.8 |  |  | 0 | 0 | 0 | 0 | 1696.8
 | 3BU |  |  |  |  |  |  | 6124.8 |  |  | 0 | 0 | 0 | 0 | 6124.8
 | 3BU |  |  |  |  |  |  | 1354.32 |  |  | 0 | 0 | 0 | 0 | 1354.32
 | 3BU |  |  |  |  |  |  | 2709 |  |  | 0 | 0 | 0 | 0 | 2709
 | 3BU |  |  |  |  |  |  | 43867.5 |  |  | 0 | 0 | 0 | 0 | 43867.5
 | 3BU |  |  |  |  |  |  | 693.6 |  |  | 0 | 0 | 0 | 0 | 693.6
 | 3BU |  |  |  |  |  |  | 1.5 |  |  | 0 | 0 | 0 | 0 | 1.5
 | 3BU |  |  |  |  |  |  | -130.2 |  |  | 0 | 0 | 0 | 0 | -130.2
 | 3BU |  |  |  |  |  |  | 11071.17 |  |  | 0 | 0 | 0 | 0 | 11071.17
 | 3BU |  |  |  |  |  |  | 38624.4 |  |  | 0 | 0 | 0 | 0 | 38624.4
 | 3BU |  |  |  |  |  |  | 969.6 |  |  | 0 | 0 | 0 | 0 | 969.6
 | 3BU |  |  |  |  |  |  | 5160 |  |  | 0 | 0 | 0 | 0 | 5160
 | 3BU |  |  |  |  |  |  | 3044.4 |  |  | 0 | 0 | 0 | 0 | 3044.4
 | 3BU |  |  |  |  |  |  | 1795.2 |  |  | 0 | 0 | 0 | 0 | 1795.2
 | 3BU |  |  |  |  |  |  | 1080 |  |  | 0 | 0 | 0 | 0 | 1080
 | 3BU |  |  |  |  |  |  | 820.8 |  |  | 0 | 0 | 0 | 0 | 820.8
 | 3BU |  |  |  |  |  |  | 3062.4 |  |  | 0 | 0 | 0 | 0 | 3062.4
 | 3BU |  |  |  |  |  |  | 4235.6 |  |  | 0 | 0 | 0 | 0 | 4235.6
 | 3BU |  |  |  |  |  |  | 1286.4 |  |  | 0 | 0 | 0 | 0 | 1286.4
 | 3BU |  |  |  |  |  |  | 3153.6 |  |  | 0 | 0 | 0 | 0 | 3153.6
 | 3BU |  |  |  |  |  |  | 34948.8 |  |  | 0 | 0 | 0 | 0 | 34948.8
 | 3BU |  |  |  |  |  |  | 55199.57 |  |  | 0 | 0 | 0 | 0 | 55199.57
 | 3BU |  |  |  |  |  |  | 6228.25 |  |  | 0 | 0 | 0 | 0 | 6228.25
 | 3BU |  |  |  |  |  |  | 1390 |  |  | 0 | 0 | 0 | 0 | 1390
 | 3BU |  |  |  |  |  |  | 4670.94 |  |  | 0 | 0 | 0 | 0 | 4670.94
 | 3BU |  |  |  |  |  |  | 2178.36 |  |  | 0 | 0 | 0 | 0 | 2178.36
 | 3BU |  |  |  |  |  |  | 1838.88 |  |  | 0 | 0 | 0 | 0 | 1838.88
 | 3BU |  |  |  |  |  |  | 1142.4 |  |  | 0 | 0 | 0 | 0 | 1142.4
 | 3BU |  |  |  |  |  |  | 88154.83 |  |  | 0 | 0 | 0 | 0 | 88154.83
 | 3BU |  |  |  |  |  |  | 966.72 |  |  | 0 | 0 | 0 | 0 | 966.72
 | 3BU |  |  |  |  |  |  | 289.12 |  |  | 0 | 0 | 0 | 0 | 289.12
 | 3BU |  |  |  |  |  |  | -7958.74 |  |  | 0 | 0 | 0 | 0 | -7958.74
 | 3BU |  |  |  |  |  |  | -81.24 |  |  | 0 | 0 | 0 | 0 | -81.24
 | 3BU |  |  |  |  |  |  | 24090.82 |  |  | 0 | 0 | 0 | 0 | 24090.82
 | 3BU |  |  |  |  |  |  | 483 |  |  | 0 | 0 | 0 | 0 | 483
 | 3BU |  |  |  |  |  |  | 4336.5 |  |  | 0 | 0 | 0 | 0 | 4336.5
 | 3BU |  |  |  |  |  |  | 2318.4 |  |  | 0 | 0 | 0 | 0 | 2318.4
 | 3BU |  |  |  |  |  |  | 1567.4 |  |  | 0 | 0 | 0 | 0 | 1567.4
 | 3BU |  |  |  |  |  |  | 1680 |  |  | 0 | 0 | 0 | 0 | 1680
 | 3BU |  |  |  |  |  |  | 1162.8 |  |  | 0 | 0 | 0 | 0 | 1162.8
 | 3BU |  |  |  |  |  |  | 2678.4 |  |  | 0 | 0 | 0 | 0 | 2678.4
 | 3BU |  |  |  |  |  |  | 9104.38 |  |  | 0 | 0 | 0 | 0 | 9104.38
 | 3BU |  |  |  |  |  |  | 2083.2 |  |  | 0 | 0 | 0 | 0 | 2083.2
 | 3BU |  |  |  |  |  |  | 1013.76 |  |  | 0 | 0 | 0 | 0 | 1013.76
 | 3BU |  |  |  |  |  |  | 28.8 |  |  | 0 | 0 | 0 | 0 | 28.8
 | 3BU |  |  |  |  |  |  | -332.5 |  |  | 0 | 0 | 0 | 0 | -332.5
 | 3BU |  |  |  |  |  |  | 52720.56 |  |  | 0 | 0 | 0 | 0 | 52720.56
 | 3BU |  |  |  |  |  |  | 1806 |  |  | 0 | 0 | 0 | 0 | 1806
 | 3BU |  |  |  |  |  |  | 1008 |  |  | 0 | 0 | 0 | 0 | 1008
 | 3BU |  |  |  |  |  |  | -151.2 |  |  | 0 | 0 | 0 | 0 | -151.2
 | 3BU |  |  |  |  |  |  | -22077 |  |  | 0 | 0 | 0 | 0 | -22077
 | 3BU |  |  |  |  |  |  | -6129.44 |  |  | 0 | 0 | 0 | 0 | -6129.44
 | 3BU |  |  |  |  |  |  | -4396.87 |  |  | 0 | 0 | 0 | 0 | -4396.87
 | 3BU |  |  |  |  |  |  | -7812 |  |  | 0 | 0 | 0 | 0 | -7812
 | 8DF |  |  |  |  |  |  | 1230 |  |  | 0 | 0 | 0 | 1230 | 0
 | 8DF |  |  |  |  |  |  | 23502.5 |  |  | 0 | 0 | 0 | 0 | 23502.5
 | 8DF |  |  |  |  |  |  | 55432.5 |  |  | 0 | 0 | 0 | 0 | 55432.5
 | 8DF |  |  |  |  |  |  | 10900 |  |  | 0 | 0 | 0 | 0 | 10900
 | 8DF |  |  |  |  |  |  | 5084 |  |  | 0 | 0 | 0 | 0 | 5084
 | 8DF |  |  |  |  |  |  | 8087 |  |  | 0 | 0 | 0 | 0 | 8087
 | 8JA |  |  |  |  |  |  | 1160.5 |  |  | 0 | 0 | 0 | 1160.5 | 0
 | 8JA |  |  |  |  |  |  | 315 |  |  | 0 | 0 | 0 | 0 | 315
 | 8TA |  |  |  |  |  |  | 6888.72 |  |  | 0 | 0 | 0 | 0 | 6888.72
 | 8TA |  |  |  |  |  |  | 2335.92 |  |  | 0 | 0 | 0 | 0 | 2335.92
 | 8TA |  |  |  |  |  |  | 1886.16 |  |  | 0 | 0 | 0 | 0 | 1886.16
 | 8WE |  |  |  |  |  |  | 7260 |  |  | 0 | 0 | 0 | 0 | 7260
 | 8WE |  |  |  |  |  |  | 3360 |  |  | 0 | 0 | 0 | 0 | 3360
 | 8WE |  |  |  |  |  |  | 9100 |  |  | 0 | 0 | 0 | 0 | 9100
 | 8WE |  |  |  |  |  |  | 4950 |  |  | 0 | 0 | 0 | 0 | 4950
 | 9EL |  |  |  |  |  |  | 10164 |  |  | 0 | 0 | 0 | 0 | 0
 | 9EL |  |  |  |  |  |  | -8652 |  |  | 0 | 0 | 0 | 0 | 0
 | 9EL |  |  |  |  |  |  | 6636 |  |  | 0 | 0 | 0 | 6636 | 0
 | 9EL |  |  |  |  |  |  | 7140 |  |  | 0 | 0 | 0 | 7140 | 0
 | 9EL |  |  |  |  |  |  | 8820 |  |  | 0 | 0 | 0 | 8820 | 0
 | 9EL |  |  |  |  |  |  | 7350 |  |  | 0 | 0 | 0 | 7350 | 0
 | 9EL |  |  |  |  |  |  | 7938 |  |  | 0 | 0 | 0 | 7938 | 0
 | 9EL |  |  |  |  |  |  | 7434 |  |  | 0 | 0 | 0 | 7434 | 0
 | 9EL |  |  |  |  |  |  | 34594.56 |  |  | 0 | 0 | 0 | 34594.56 | 0
 | 9EL |  |  |  |  |  |  | 5040 |  |  | 0 | 0 | 0 | 5040 | 0
 | 9EL |  |  |  |  |  |  | 6552 |  |  | 0 | 0 | 0 | 6552 | 0