Related:
- Subtracting numbers based on data in another cell
- Tmobile data check - Guide
- Instagram account based in wrong country - Instagram Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
1 response
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!
It's kind of fun to do the impossible! -Walter Elias Disney
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!
It's kind of fun to do the impossible! -Walter Elias Disney
