running balance
 

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

-----Original Message-----
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
.

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

Thanks a lot. The array formula worked.

"cwilson" wrote:

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

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?



"cwilson" wrote in 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

hi again.
oops. forgot to add copy cell d3 down.
sorry.

-----Original Message-----
deposits-disbursements-expenses+previous balance

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

hope this helps

-----Original Message-----
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
.

.

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
.

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.

"Lady Layla" wrote:

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?



"cwilson" wrote in 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

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


wrote in message
...
: 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.

" wrote:

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
.