Ok received alot of help here before hoping you can help again.

Table below showing my data on sheet1
Acc M1 M2 M3 Type
406 100 100 0 R
406 300 200 50 G
406 0 0 10 H
506 30 800 0 R
506 0 0 300 G

Ok I first need all totals of columns M1,M2,M3 where Acc is equel (assuming
this will done on another sheet)
So you would get -

406 400 300 60
506 30 800 300

Secondly (on again another sheet the total) I need to move all the "R" rows
to another sheet - I would then do the same for H,G. So the R sheet would
become

406 100 100 0
506 30 800 0

I do have an understanding of naming rows if that would ease things.
I hope this makes sense. Thanks in advance for any help