Sum total when name changes

[Marq1995]

Hi all,

I need you to help me.. Im loosing sleep! haha

What I want to do is sum up the debit and credit column and add the total in the blank row (when the name value changes). But, if the value is <0 I want the total to go in the debit column - if it is >0 I want it to go in the credit column

I hope that makes sense...

Please help!!

I

 

[Marq1995]

Haha awesome!

Honestly, thank you so much for your help! Massively appreciate it ?