I have a large worksheet which looks a bit like this:

Name M1 M2 M3
A, A 1
A, A 1 2
A, A 1
B, B 3 1
C, C 1 1 2
C, C 2 3
C, C 1

What I'd like is to insert 2 rows above a Name change and total the columns (followed by a blank) so that it looks like this:

Name M1 M2 M3
A, A 1
A, A 1 2
A, A 1
total 2 2 1

B, B 3 1
total 3 1

C, C 1 1 2
C, C 2 3
C, C 1
total 2 3 5

Can this be done easily?

Thanks,
Alison.