Hello,
Im hoping there will be a simple fix for this one:
I have a running balance spreadsheet with the data as follows:
Row 1 - Headers
A2 - Date
B2 - Item
C2 - Credit
D2 - Debit
E2 - Balance
In column E I have the following formula:
First row: =SUM(C6-D6)
Second row (copied down): =SUM(E6,C7-D7)
This all works great, until I delete a row or shift cells down etc.
what is wrong? can anyone help me?
I have attached a sample.
Hope someone can help me
regards,
Michael
Bookmarks