I should have added ... for the sums, again assuming there is an equal
number of rows that can be summed in each column, and also assuming
ColTotal1 is in cell E50:

E50 = sum($e1:e49)

Then you can copy to F50 and as far to the right as you want.