Maybe instead of inserting a row for each total, you make the running total in a separate column. Or you can use the sun if formula. Use sumif to get the total including the total line, minus a sumifs formula that is only looking for lines that say John international first column and total in the second column, so that you are subtracting out all of the totals.
Or just use one sumif formula with 2 conditions. The first condition is that that the first column is equal to John and the second column is not equal to total.
But it would be helpful to know what exactly you are trying to accomplish with this spreadsheet. I wonder if there isn't an easier/cleaner way to do what you are trying to do.