Hello.

I'm trying to make a Financial/Spending Sheet for someone, and it's been a while since I've had to use Formula's in Excel so I'm not sure what to do.

There are 3 bank account sums, all of a different value. How do I set it up so that when they put something like " -£20" in the "spent" column, it will automatically remove that sum of money from the correct bank account total cell?

Thanks.