Formula to adjust the value of a cell, based on changes to drop down list options

• J_doe 

• working on an excel budget workbook. I have no idea if a formula like this is possible

   

  I guess you need an online form to append new records.

  demo

 Then you can download the datas to Excel for further analysis. You can use formular,PQ or sql.

By the way,it is easy to summary or analysis if you save both deposit/balance and expenses in one sheet rather than split to several sheets.