Hi,

I have a worksheet in which I have a date column, amount column &
amount as entered/collected column.

column1 column2 column3
1/1/1980 1000 collected
4/1/1980 -500 entered
6/2/1980 200 collected
4/2/1980 -1500 entered
7/2/1980 2100 collected
9/5/1980 -5000 entered
6/3/1980 2000 collected



and so on.

Result:
Something like running balance. at the end for fifth month it should
show -1700

Column5 column6
January 500
February 1300
March 3300
April 3300
May -1700

No pivot table pls : )