How to do a running total of different accounts in a table

Morning guys

I decided to build myself a finance spreadsheet to help keep track of my money and goals

I have a list of transactions in a Table from my current account with running total for each transaction. I then added an "Account Type" column with a drop down list to choose either "Current" or "Savings" this is where I am stuck. How can I get my running total to "realise" there are 2 different accounts now and they should be treated separately rather than using both accounts for the running total

Any help would be greatly appreciated

Thanks

Jonny

Here is a shortened example

Thanks for the input guys!

Cheers

Jonny

I like that set up especially choosing the accounts option Popipipp I would like to possibly having a running total after every transaction for both accounts

For example
If I click current account there will be a column own the side of Sum Paid Out called something like Balance and it updates after every transaction entered or maybe have 2 columns one for savings and one for current?

What do you guys think?

Glenn that layout is along the lines of what I was thinking

I have applied the formula to my transactions sheet everything is perfect except I had to change the formula in the savings column from

=SUMIF(A$6:A76,"Savings",F$6:F76)+SUMIF(A$6:A76,"Savings",G$6:G76) to

=SUMIF(A$6:A76,"Savings",F$6:F76)-SUMIF(A$6:A76,"Savings",G$6:G76) as my balance's where coming out negative?

Once I changed it to a negative in the formula my balances went positive however when there is a "Paid Out" it
still adds this onto the savings balance where it should subtract this from the savings balance

Any advice?

Many Thanks

Jonny

Thats it working perfectly now I am not sure what went wrong I think it was down to me not using double entry for bank transfers after I done this and used the original formula it was all good!

Thank you very much for you time and help!

Jonny