I have this data set where I am using this formula to calculate the outstanding course fee but when I am putting the amount received its not deducting the remaining amount from the total course fee and showing in the next record. I am not able to work this out with sumif formula, any help will be highly appreciated.

=IF(AND(ISBLANK(A5)),"",VLOOKUP(A5,Student_Registration!$B$5:$H$2000,7,0)-SUMIF($A$5,A5,$I$5))

Sample worksheet :