+ Reply to Thread
Results 1 to 4 of 4

Cannot add up multiple column data

  1. #1
    Registered User
    Join Date
    12-17-2015
    Location
    Penrith
    MS-Off Ver
    2007
    Posts
    27

    Cannot add up multiple column data

    I'm trying to add up all staff hours from different sections of work seperately. I have 1 column of numbers for the amount of time worked, but sometimes there is more than one staff member on a section of work so the names are in two columns. I just want to get the total of all hours worked for a member of staff when their name is in the same row as a number, but it will currently only add up the hours when the name is in the first column not if it's in the second one.

    At the base of the sheet I currently have a list of all staff names and then columns for HS work, DCH work, admin, DC etc as the pay rates are different.
    for the HS and DCH work next to each staff member I have the formula:

    =SUMIF($F:$G,"JOBLOGGS",D:D)

    (- note - I actually have each staff name in each one)
    but it only adds up the hours from column D if the name appears in column F not G.

    Please can someone help I'm stumped and feel like it shouldn't be that tricky but for the life of me can't get it to work. If I try having two columns with the same formula but one just for column F and one for column G it still doesn't add up hours if the same appears in column G.

    There needs to be 2 columns as often 2 staff members go to the same call.

    There seems to be lots of formulas for adding up multiple columns of numbers to match one name, but not adding up numbers from one column from 2 columns of the name, and they don't seem to be working for me in reverse.

    I have attached a sample page (note all names are changed for confidentiality)Book1.xlsx

    Any help would be greatly appreciated.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Cannot add up multiple column data

    If I'm following your issue correctly, try this instead... =SUMIF($F:$F,"JOBLOGGS",D:D)+SUMIF($G:$G,"JOBLOGGS",D:D)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    12-17-2015
    Location
    Penrith
    MS-Off Ver
    2007
    Posts
    27

    Re: Cannot add up multiple column data

    hi,
    ah thanks so much! that's solved it!
    cheers,
    I knew it must be fairly straightforward but was just eluding me.
    Have a nice day cheers so much

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Cannot add up multiple column data

    Glad I could help. And if you are so inclined clicking on "* Add Reputation" is a way to thank those who help you on this forum, it is how we advance.

+ 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. Merge specific column data from multiple sheets in single column of new workbook.
    By kadam203 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2016, 01:58 AM
  2. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  3. Transpose Data from a Particular Column to Multiple Column whose Range is Non-Continuous!
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:47 AM
  4. Replies: 4
    Last Post: 06-08-2012, 03:24 PM
  5. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  6. Replies: 2
    Last Post: 11-28-2011, 06:10 PM
  7. Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns
    By nzxt1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 01:17 AM

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