Carrying a balance forward

[Melanie Savasta]

Good morning/afternoon to everyone

I would like calculate a balance.
Example:

$5000.00 in an account, subtracting different amounts
on different dates - I would like excel to show a
continuing balance when amounts are subtracted.

I hope this explanation is clear.

Thanks

[Don Guillett]

where a1 contains 5000, something like

=$a$1-Sum($a$2:a2)
copy down


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Melanie Savasta" <melanie.savasta@cnh.com> wrote in message
news:%237ykrhvYGHA.3972@TK2MSFTNGP04.phx.gbl...
> Good morning/afternoon to everyone
>
> I would like calculate a balance.
> Example:
>
> $5000.00 in an account, subtracting different amounts
> on different dates - I would like excel to show a
> continuing balance when amounts are subtracted.
>
> I hope this explanation is clear.
>
> Thanks
>
>

[Ardus Petus]

Assuming:
Initial balance in B2 = 5000
negative amounts in B3:B99

in c2, enter:
=SUM(B$2:B2)
and copy down

HTH
--
AP

"Melanie Savasta" <melanie.savasta@cnh.com> a écrit dans le message de
news:%237ykrhvYGHA.3972@TK2MSFTNGP04.phx.gbl...
> Good morning/afternoon to everyone
>
> I would like calculate a balance.
> Example:
>
> $5000.00 in an account, subtracting different amounts
> on different dates - I would like excel to show a
> continuing balance when amounts are subtracted.
>
> I hope this explanation is clear.
>
> Thanks
>
>