Carrying a balance forward
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 |
Carrying a balance forward
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 |
Carrying a balance forward
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 |
All times are GMT +1. The time now is 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com