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
Bookmarks