Running Totals for Bank Balances

Hi

Just looking for a simple formula that calculates a running total of a bank balance with an additional variable of account/credit card provider so, depending on where the money is being spent or deposited, it will calculate the balance per transaction. Very simple I know but I have a mental block! Example attached.

Thanks!

Try this,

E5

Please Login or Register  to view this content.

copied down.

Thanks - that worked perfectly!

Hi

I have now added a 3rd credit card to my account but this means that the IF function no longer works as there are 3 variables. Can you tell me what I need to add to the formula please?

Try this in E5

=XLOOKUP($F5,$1:$1,$2:$2)+SUMIF($F$5:F5,$F5,$D$5:D5)

copied down.

hi there, I allow to propose another possible solution:

Please Login or Register  to view this content.

Also, I warning to avoid the use relative reference in a Table because can be a problem when delete or change the data in the last row, so its better to use mix reference to prevent that situation.

I hope it results useful.

Bank Balances (Solution).xlsx

Thank you - that's great