running balance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
deposits-disbursements-expenses+previous balance

In cell D2 put =A2-B2-C2
In cell D3 put =A3-B3-C3+D2

hope this helps
 
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
 
Thanks a lot. The array formula worked.

cwilson said:
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
Click to expand...
 
Why would you have to enter this as an array -- works as a simple formula (no
need to do the ctrl+shift+enter) What would an array do that a normal formula
wouldnt?



: 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
 
You are correct. I don't know why I had it as an array. To much going on at
once maybe. Thanks though. Good catch.
 
OP wants to know how much money at any one time..... the Formula here works just
fine without having to page down to the bottom of the entries to see the total


: 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
: >.
: >
 
Well sorry I wasn't sure if balance was the correct term since my balance
keeps on changing constantly when I enter new data.
 
Back
Top