that is not what i call a running balance. that is just a
balance.
-----Original Message-----
how about an array formula?
Type into D2 (or where ever you want to see the running
balance)
=sum(A2:A1000)-sum(B2:B1000)-sum(C2:C1000) then do
ctrl+shift+enter
each time you enter new dollar amounts in the columns
(all as positive
numbers by the way) the amount balance in D2 will change
to reflect the new
transaction.
HTH cwilson
"Jackie" wrote:
Hi I need help figuring out a formula for a running
balance. I have 3
columns one called deposits, another called petty cash
disbursements and
another called expenses. I want to be able to know how
can I get the total
amount of money that I have on an account even though I
keep on entering
different dollar amounts at all times. I know that the
formula =A39-B39 is
giving me the amount for the first two columns, but I
don't know what to do
for the third column.
I would really appreciate it if someone can help me out.
Thanks.
Jackie
.
|