One way is to use the SUM() function for your total (ending balance) and
enter the amounts to be deducted as negative values by using a minus sign or
enclosing them in parentheses.

You could also build a formula such as =A1-A2-A3-A4, etc.

Other ways are also possible.

Hope this helps |:)

"Theresa" wrote:

How do I set up a formula that will deduct from a beginning balance and keep
an ending balance as I add items to be deducted?