Could use have a formula that controls the division ranges (maybe by
changing a value in a cell at the top). If you could do that then you
could use a pivot table to easily get totals. If not I can point you
in the right direction with VBA.