Subtraction formula that is based on another formula

cdeplato

Hi everyone,

Please send help.

I have a formula set up to calculate total costs. However, I need to have it set up so that the total amount subtracts from a budget total.

For example, say the budget it 20,000. I need the =SUM(Amount:Amount) to automatically subtract from the 20,000.

I hope this makes sense. Thank you!

Mark.poole

@cdeplato

=20,000-Sum(Amount:Amount)

Just replace the 20,000 with the cell reference of your budget total

Mark.poole

@cdeplato

=20,000-Sum(Amount:Amount)

Just replace the 20,000 with the cell reference of your budget total

cdeplato

Thank you so much!