Q: Identifying a moving cell
Thanks for the earlier reply but here is my question once again. In the following sheet, I want to move the calculation in column E to F2. The calculation of column E changes each time an entry is made. The running total column (E) includes a pretty simple calculation -C2+D2+E1.
|
|
|
|
|
|
|
Date | Category | Debit | Credit |
|
| Running Total |
|
|
|
|
|
|
|
6/12/2013 | Checking |
| $10,000.00 | $10,000.00 |
|
|
| savings |
| $10,000.00 | $20,000.00 |
|
|
| Cash |
| $400.00 | $20,400.00 |
|
|
| Medical | $ 100.00 | $0.00 | $20,300.00 |
|
|
| Food | $ 900.00 |
| $19,400.00 |
|
|
| Spending | $ 600.00 |
| $18,800.00 |
|
|
| Gas | $ 100.00 |
| $18,700.00 |
|
|
| Utilities | $ 100.00 |
| $18,600.00 |
|
|
| Phone |
| $200.00 | $18,800.00 |
|
|
| TV | $ 10.00 |
| $18,790.00 |
|
|
| Gifts | $ 655.00 |
| $18,135.00 |
|
|
| Misc | $ 1,000.00 |
| $17,135.00 |
|
|
| Vacation | $ 5,000.00 |
| $12,135.00 |
|
|
|
|
|
| $12,135.00 |
|
|
|
|
|
|
|
|
|
MacBook Air, Mac OS X (10.6.8)
Posted on Sep 19, 2016 2:43 PM
Hi k'
A "running total" generally refers to the figures you have in column E—each value shows the total to that point in time.
You want the 'current total' or 'most recent total' to be displayed in a specific cell in column G.
The "current total," simply expressed is the 'opening balance' plus 'the sum of the credits' minus 'the sum of the debits'.
In your table, the 'opening balance' is zero, and may be ignored.
The credits are recorded in column D, so the 'sum of the credits' is SUM(D).
The debits are recorded in column C, so the 'sum of the debits' is SUM(C).
The formula for the current balance (or current total) is =SUM(D)-SUM(C)
This formula may be placed in any cell in any column other than D or C.
Regards,
Barry
Posted on Sep 22, 2016 7:13 AM

