Report

Subtracting numbers based on data in another cell

Ask a question drspinner - Last answered on Oct 4, 2017 at 03:59 PM by ac3mark
I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the input to the cell with the alpha character?


m $235.00 d 09/26/17

So I input d and want to deduct the money amount from a cell that keeps a running total of other monies.

Thanks
Helpful
+0
plus moins
Input the money amount as a negative, and SUM all of the numbers!

So, if your running total is in Cell Z1, the formula in cell Z1 would be:
=SUM(A1:Y1)

A1 = 1500.00 (starting amount)
B1 = -450.00 (deduction)
C1 = 45.00 (deposit)
D1 = -15.00

Z1 would = 1080.00
Try that!

If this is not what was expected, let us know why this won't work!

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!