Moving totals of rows in sort mode

[rz]

I am to prepare the accounts ledger in my database of vouchers by
sorting on account code. When I drag the formula of totals of + debit
- credit column with the same coloumn total in immediately DISPLAYED
ROW ABOVE THE FORMULA CELL row, it do not show the desired result as
the cell refernce of DISPLAYED SORTED ROWS is not automatically linked
while dragging the formula downward. Any solution to make the ledger
totals on right side of every transaction (row).
Thanks
Riaz

 

[Billy Liddel]

I am to prepare the accounts ledger in my database of vouchers by
sorting on account code. When I drag the formula of totals of + debit
- credit column with the same coloumn total in immediately DISPLAYED
ROW ABOVE THE FORMULA CELL row, it do not show the desired result as
the cell refernce of DISPLAYED SORTED ROWS is not automatically linked
while dragging the formula downward. Any solution to make the ledger
totals on right side of every transaction (row).

Riaz

You need an expanding range - for the following data:


Date Ac No# Debit Credit Amount
01/06/2008 a123 20 20
02/06/2008 b123 30 30
04/06/2008 c123 50 50
11/06/2008 b123 20 10
14/06/2008 a123 10 10
06/10/2008 c123 40 10

Enter the amount formula in E2

=SUMIF($B$2:B2,B2,$C$2:C2)-SUMIF($B$2:B2,B2,$D$22)

and copy down.

Regards
Peter Atherton