Hi

I advice a different design, which is more flexible.

On empty sheet, into range A1:C1 enter headers
Date, Account, Sum

E1="Balance:"
F1=SUMIF(B:B,"Income",C:C)-SUMIF(B:B,"Spending",C:C)

Format column A as Date in any valid date format on your choice.
Format column C and cell F1 as Currency (or General or Number)

Whenever you add money, enter "Income" as account into column B, and the sum
(positive number) into column C..
Whenever you substract money, enter "Spending" into column B, and again the
sum (again positive number) into column C.
(Every transaction will be in separate row. My advice is also to apply data
validation list to column B, so you can select accounts from dropdown, and
non-standard entries will be restricted)
You can have any number of different transactions, both Income and Spending,
and current balance is calculated immediately.

When you enter transaction date for every transaction too, then you can
design some report sheet(s), where start and end balances for selected time
interval, and summary incomes and spendings for this time interval are
displayed.

To prevent headers and balance to be hidden when scrollung down the table,
use Freeze Panes feature to freeze 1st row on top of Excel window. And
applying Autofilter to your transaction table may be useful too.


Arvi Laanemets


"Bunnie" wrote in message
...
I want to create a chart with a major number, then input various debit
amounts in the next cells across and end with a final cell showing the
balance left. I have tried "sum" but have not been successful. I work
across
the chart not down.

Example in C1 entered $2000 as opening amount, then subtract from C2 $225,
C3 $150, C4 $467, C5 $825. C 15 should then show a remaining balance of
$333.
--
Busy Bunnie