+ Reply to Thread
Results 1 to 5 of 5

Pull values from Multiple columns that are spread apart

  1. #1
    Registered User
    Join Date
    04-16-2015
    Location
    Liverpool, England
    MS-Off Ver
    2013
    Posts
    2

    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

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Pull values from Multiple columns that are spread apart

    Hi Dodie,

    Why don't have sum in Totals and then have SUM function summing up of all totals in Overall.

    I don't know if you are not looking for the same as this is what i have understood.
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

  3. #3
    Registered User
    Join Date
    04-16-2015
    Location
    Liverpool, England
    MS-Off Ver
    2013
    Posts
    2

    Re: Pull values from Multiple columns that are spread apart

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

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,828

    Re: Pull values from Multiple columns that are spread apart

    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
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Pull values from Multiple columns that are spread apart

    Hi Dodie,

    Better If you upload the attachment as said before for clear understanding with raw data and expected result. Uploading image for such instance, will never get you exactly what you are looking at. Also, there may be chances of delay in getting expected result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to group values spread across columns in Pivot
    By Excelreserve in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-12-2015, 03:46 PM
  2. [SOLVED] VBA formula with multiple variables to pull data from spread sheet.
    By topnotchthrillr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2015, 12:30 AM
  3. Replies: 1
    Last Post: 04-28-2014, 06:47 AM
  4. [SOLVED] Need to pull multiple reference points into one spread sheet
    By oniete1997 in forum Excel General
    Replies: 10
    Last Post: 04-05-2012, 10:18 PM
  5. Relating multiple columns in two spread sheets
    By Cemt5462 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-01-2011, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1