Instead of copy of paper table from 18.-19. century, use a table with structure like
Name, Amount1, Amount22, Amount222
or even better
Name, WhateverParameter, Amount

Then you can simply create a pivot table which will give you any totals and subtotals you need.