Example as to a formula I need

Add Subtract Balance
Column C Column I Column J
$1000 -$500 =$500

All columns are set up to start with row C14 and finish with C100
I column starts with row I14 and finish with I 100
J column starts with row J14 and finish with J100

Columns C & I presently have amounts in each cell. Where there are no
actual amounts, I have $0.00 to fill cell
Column J has no figures at all except all cells have $0.00

Could someone please create a formula for me that would give me a continous
running balance in Column J based on the above information

--
Thank you in advance for your assistance
HankL

Hank,
C I J
14 1000 500 =C14-I14
15 =J14+C15-I15

Copy the formula in J15 down to J100 by dragging the Fill Handle down. You
might instead want to put a starting balance in J14 instead of the formula
(though it could also go in C14)

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Hank Laskin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Example as to a formula I need
>
> Add Subtract Balance
> Column C Column I Column J
> $1000 -$500 =$500
>
> All columns are set up to start with row C14 and finish with C100
> I column starts with row I14 and finish with I 100
> J column starts with row J14 and finish with J100
>
> Columns C & I presently have amounts in each cell. Where there are no
> actual amounts, I have $0.00 to fill cell
> Column J has no figures at all except all cells have $0.00
>
> Could someone please create a formula for me that would give me a
> continous running balance in Column J based on the above information
>
> --
> Thank you in advance for your assistance
> HankL
>