On Jun 7, 7:41*pm, Mike H wrote:
hi,

Try this wth jan etc in E1 down
in F1

=SUMPRODUCT((MONTH($A$1:$A$7)=ROW(A1))*($B$1:$B$7) )

and then this in F2 and drag down
=E1+SUMPRODUCT((MONTH($A$1:$A$7)=ROW(A2))*($B$1:$B $7))

Mike



"Sinner" wrote:
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/1982 * * * -500 * * * * *entered
6/2/1980 * * * 200 * * * * * collected
4/2/1981 * * * -1500 * * * * *entered
7/2/1980 * * * 2100 * * * * * collected
9/5/1982 * * * -5000 * * * * *entered
6/5/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 : )- Hide quoted text -

- Show quoted text -

Hi,

A little modification for yearly match.

I want to list same balances monthly/year like

1980
Jan (amount)
Feb (amount)
March (amount)
April (amount)

1981
Jan (amount)
Feb (amount)
March (amount)
April (amount)

1982
Jan (amount)
Feb (amount)
March (amount)
April (amount)