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

 

[Ardus Petus]

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

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

HTH