Hello, I'm trying to make a small application in Excel. For example, 12 payment records are kept in a table. I want it to be deducted from the total amount of money when "paid" is written in the cell next to the received payment in these records. I made a study, but as you will see in the appendix, I cannot maintain it in the same cell. How can I check this?
formule is: =IF($E3="Paid",D14-D3,D14) but I actually want to check it in the cell where the total money is not a single row, it should change automatically according to the value of 12 cells. scrolling down like this is not a solution for me. What can I do?