I have an item shop and bank account set up for my students in class using Sheets. Currently students purchase their items via Google Forms and it logs their order in a Sheet. Normally, I would find that student on the bank sheet and subtract from their account the total cost of their order, but I feel like there is a way that I can have google automate the process.
For example: Student1 spends $100.00 and then student27 spends $50.00
Is there a way for Sheets to find those unique individuals and then input a negative amount into their bank accounts?