Spreadsheet: 55235d1255395540-a-formula-to-work-out-different-sums-in-one-column-sample
Sheet: Sheet1

 | Month | Cash | Credit | Sums |  |  |  |  |  | Month | Cash | Credit | Sums
 | 2009-01-01 00:00:00 | 100 | 30 | 155 | ←Month Credit |  |  |  |  | 2009-01-01 00:00:00 | 100 | 30 | 155 | ←Month Credit
 |  | 80 | 75 |  |  |  |  |  |  |  | 80 | 75
 |  |  |  | 455 | ←Month Total |  |  |  |  |  |  |  | 455 | ←Month Total
 |  | 120 | 50 | 455 | ←Progressive Total |  |  |  |  |  | 120 | 50 | 455 | ←Progressive Total
 | 2009-02-01 00:00:00 |  |  | 105 | ←Month Credit |  |  |  |  | 2009-02-01 00:00:00 |  |  | 105 | ←Month Credit
 |  | 95 | 65 |  |  |  |  |  |  |  | 95 | 65
 |  | 95 |  | 385 | ←Month Total |  |  |  |  |  | 95 |  | 385 | ←Month Total
 |  | 90 | 40 | 840 | ←Progressive Total |  |  |  |  |  | 90 | 40 | 840 | ←Progressive Total
 | 2009-03-01 00:00:00 | 70 | 25 | 100 | ←Month Credit |  |  |  |  | 2009-03-01 00:00:00 | 70 | 25 | 301 | ←Month Credit
 |  | 130 | 45 |  |  |  |  |  |  |  | 130 | 45
 |  |  | 30 | 360 | ←Month Total |  |  |  |  |  |  | 30 | 360 | ←Month Total
 |  | 60 |  | 1200 | ←Progressive Total |  |  |  |  |  | 60 |  | 1200 | ←Progressive Total
 | 2009-04-01 00:00:00 | 100 | 12 | 12 | ←Month Credit |  |  |  |  | 2009-04-01 00:00:00 | 100 | 12 | 201 | ←Month Credit
 |  |  |  | 112 | ←Month Total |  |  |  |  |  |  |  | 112 | ←Month Total
 |  |  |  | 1312 | ←Progressive Total |  |  |  |  |  |  |  | 1312 | ←Progressive Total
 | 2009-05-01 00:00:00 | 40 | 70 | 150 | ←Month Credit |  |  |  |  | 2009-05-01 00:00:00 | 40 | 70 | 150 | ←Month Credit
 |  |  | 80 | 190 | ←Month Total |  |  |  |  |  |  | 80 | 190 | ←Month Total
 |  |  |  | 1502 | ←Progressive Total |  | The problem is:  The values of "Month Total" & "Progressive Total" are not appearing in the table [on the left].  When a number is added in cell B61, these values appear [which I understand]. But ( as seen in the copy on the right), the Month Credit from October/09 down changes to include the values of the succeeding months' "Month Credit" [which I don't understand]. |  |  |  |  |  | 1502 | ←Progressive Total
 | 2009-06-01 00:00:00 |  |  | 0 | ←Month Credit |  |  |  |  | 2009-06-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total |  |  |  |  |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total |  |  |  |  |  |  |  |  | ←Progressive Total
 | 2009-07-01 00:00:00 |  |  | 10 | ←Month Credit |  |  |  |  | 2009-07-01 00:00:00 |  |  | 10 | ←Month Credit
 |  | 50 |  |  |  |  |  |  |  |  | 50
 |  |  |  | 60 | ←Month Total |  |  |  |  |  |  |  | 60 | ←Month Total
 |  |  | 10 | 1562 | ←Progressive Total |  |  |  |  |  |  | 10 | 1562 | ←Progressive Total
 | 2009-08-01 00:00:00 |  |  | 0 | ←Month Credit |  |  |  |  | 2009-08-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total |  |  |  |  |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total |  |  |  |  |  |  |  |  | ←Progressive Total
 | 2009-09-01 00:00:00 |  |  | 0 | ←Month Credit |  |  |  |  | 2009-09-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total |  |  |  |  |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total |  |  |  |  |  |  |  |  | ←Progressive Total
 | 2009-10-01 00:00:00 |  | 15 | 15 | ←Month Credit |  |  |  |  | 2009-10-01 00:00:00 |  | 15 | 29 | ←Month Credit
 |  |  |  | 15 | ←Month Total |  |  |  |  |  |  |  | 15 | ←Month Total
 |  |  |  | 1577 | ←Progressive Total |  |  |  |  |  |  |  | 1577 | ←Progressive Total
 | 2009-11-01 00:00:00 | 20 |  | 4 | ←Month Credit |  |  |  |  | 2009-11-01 00:00:00 | 20 |  | 14 | ←Month Credit
 |  |  | 4 |  |  |  |  |  |  |  |  | 4
 |  |  |  | 24 | ←Month Total |  |  |  |  |  |  |  | 24 | ←Month Total
 |  |  |  | 1601 | ←Progressive Total |  |  |  |  |  |  |  | 1601 | ←Progressive Total
 | 2009-12-01 00:00:00 |  | 10 | 10 | ←Month Credit |  |  |  |  | 2009-12-01 00:00:00 |  | 10 | 10 | ←Month Credit
 |  | 13 |  |  | ←Month Total |  |  |  |  |  | 13 |  | 23 | ←Month Total
 |  |  |  |  | ←Progressive Total |  |  |  |  |  |  |  | 1624 | ←Progressive Total
 |  |  |  |  |  |  |  |  |  | 111