Thread
:
Sum by month running balance
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Sum by month running balance
One way
in d2=b2
in d3=d2+b3 copy down
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Sinner" wrote in message
...
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 : )
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett