Moving totals of rows in sort mode

  • Thread starter Thread starter rz
  • Start date Start date
R

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
 
rz said:
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).
Click to expand...

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$2:D2)

and copy down.

Regards
Peter Atherton
 
Back
Top