Pull values from Multiple columns that are spread apart

Hi,

Looking to Sum multiple columns that sum several columns between each other. Please see below for what i mean.

Name	Trade	Mon	Tue	Wed	Thurs	Fri	Sat	Sun	Total	Mon	Tue	Wed	Thurs	Fri	Sat	Sun	Total	Overall
Dude1	Chainman	120	120	156	198	352	120	0	1066	120	120	156	198	352	120	0	1066	2132
Dude2	Groundworker	120	120	156	198	352	120	0	1066	120	120	156	198	352	120	0	1066	2132
Dude3	Pipelayer	120	120	156	198	352	120	0	1066	120	120	156	198	352	120	0	1066	2132
Dude4	Chainman	120	120	156	198	352	120	0	1066	120	120	156	198	352	120	0	1066	2132

What I want is a total for each trade. What I haven't shown here is that the main spreadsheet covers 30 weeks for over 50 people.

If there is a formula that'll save me from clicking on each line that'd be magical.

Many Thanks,

Dodie9

Thank You good sir. Knew a fresh set of eyes would help me out XD

Hi Dodie9,

Your requirement is not clear , i have uploaded file along with a formula which may help you

If that is not your requirement please provide the result manualy in the sheet for better and fast responce

Punnam