Would like some sort of worksheet change event code.
I'd make it part of the Worksheet_Deactivate event since you might be adding a number of rows with multiple columns

I don't think I'd like it activating each time there was ANY change


total columns are A-E.
You mean A and E? Not A through E?

How are the totals calculated: one day, running, beginning to end, ...?