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

where a1 contains 5000, something like

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


--
Don Guillett
SalesAid Software

"Melanie Savasta" wrote in message
...
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

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" a écrit dans le message de
...
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