I want a formula in excel.10 that I have some amounts in Column "A" and their comments in column "B". If I write the text "RECEIVED" in Cell B5 so it automatically deduct the amount of cell "A5" from the sum of A:A, for example
i have some amounts in column A5:A10. and Remarks in column B5:B10. Sum of A5:A10 is in A11. And i write a comment "RECEIVED" in cell B6, so formula will deduct the value of Cell A6 from "A11 (sum of A5:A10) and gives me the result in Cell B11 that your remaining Balance is this.