Mar 11 2022 11:53 PM
Hello Everyone,
I would like the number in cell C2 to decrease every time I add a number to the whole of the column C. I would like for any number I enter into the B column to be subtracted automatically from the C2 cell every time a new number is written.
What formula should i write?
Please help..??
Here is a attached file...
Mar 12 2022 12:09 AM
Mar 12 2022 12:25 AM
Mar 12 2022 12:50 AM
Mar 12 2022 12:53 AM
I think you want to do this row by row. I would not recommend that: you would not have a history of changes, and it would be very difficult to correct mistakes.
But if you really want it, you could use the Worksheet_Change event procedure. See the attached version (now a .xlsm workbook)
Mar 12 2022 02:10 AM
SolutionMar 12 2022 09:22 AM
With an up to date version of 365, one could have
= IF(paidBack,
SCAN(loanAmount, paidBack,
LAMBDA(acc,p, acc-p)),
"")
which grows dynamically
Mar 12 2022 02:10 AM
Solution
Use this formula =$C$2-SUM($B$3:B3). Also, I have attached screenshot for reference.