On a current account banking statement I have the current month's activities
with a running total at the bottom - all very simple.
Within the monthly activites are four cells indicating transfers to a
savings account. These are, of course, minus figures as being paid out.
Below the current account total I have a cell that shows a total for these
transfers to the savings account. (This total is projected elsewhere for the
savings account's main data) At the moment I total the transfers manually
because a simple 'Total' (D7+D17+D26+D38) gives a negative sum - which is
bad news for the savings account!
Is there a formula that can total these entries but show it as a positive
Sum?
TIA
Ed
