+ Reply to Thread
Results 1 to 4 of 4

sum the rows in column D when concatenated column C,E,H has same value

  1. 10-26-2015, 08:23 AM #1
    gurtejhira
    gurtejhira is offline
    Registered User
    Join Date
    08-04-2015
    Location
    newyork
    MS-Off Ver
    2010
    Posts
    16

    sum the rows in column D when concatenated column C,E,H has same value

    will appreciate if someone can help me out

    I have a excel file with A to I columns filled and I like to sum the rows in column D only if concatenated column C,E and H have same value

    for.eg.

    CA CA-FNR CA-19 1400 1800 12 20150201 0
    CA CA-FNR CA-19 1500 1900 12 20150201 0
    CA CA-FNR CA-19 2000 1800 12 20150201 0
    CA CA-FNR CA-19 2000 1800 12 20150201 0
    CA CA-FNR CA-19 1800 1900 12 20150201 0
    CA CA-FNR FA-19 1800 1900 12 20150201 0

    Desired Result
    CA CA-FNR CA-19 5400 1800 12 20150201 0
    CA CA-FNR CA-19 3300 1900 12 20150201 0
    CA CA-FNR FA-19 1800 1900 12 20150201 0

    Appreciate your help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-26-2015, 08:36 AM #2
    bsuperiorsystem
    bsuperiorsystem is offline
    Registered User
    Join Date
    10-07-2015
    Location
    Vancouver, BC, Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: sum the rows in column D when concatenated column C,E,H has same value

    the best solution is pivottable
    please find the attached

    note: put a header for your column.I put as Senario1 ......senario9

    for repeating the record in your pivot table, go and click:

    design>report layout>repeat all item label


    Feel free to find more tutorials on my Excel Blog.
    Attached Files Attached Files
    Last edited by bsuperiorsystem; 10-26-2015 at 08:43 AM.
    Reply With QuoteRegister To Reply
  3. 10-26-2015, 11:02 AM #3
    gurtejhira
    gurtejhira is offline
    Registered User
    Join Date
    08-04-2015
    Location
    newyork
    MS-Off Ver
    2010
    Posts
    16

    Re: sum the rows in column D when concatenated column C,E,H has same value

    thank you superior it worked. I wish if there is any other way to make it more simple but for now this will keep me moving
    Reply With QuoteRegister To Reply
  4. 10-26-2015, 12:33 PM #4
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: sum the rows in column D when concatenated column C,E,H has same value

    In cell D14 of your example workbook, enter the following formula.
    It may then be copied down.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count unique text from multiple columns concatenated w/ one column
    By lopez235 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2015, 08:54 PM
  2. copying only rows with data in first column - skipping rows with a blank first column
    By uptickdk in forum Excel General
    Replies: 4
    Last Post: 05-16-2014, 04:52 PM
  3. Combine rows by adding amounts found in column d for duplicate names in Column a
    By bnasty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 09:29 PM
  4. Excel 2007 : Rows with 'wordA' in any column AND 'wordB' in any column, case sensitive, multiple files
    By janschepens in forum Excel General
    Replies: 2
    Last Post: 05-27-2012, 09:43 AM
  5. Forumla for Moving/Copy Data from Single Column (Rows) to Multiple Column
    By thchughesmathews in forum Excel General
    Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  6. align 3 concatenated strings for column appearnace
    By Dano in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-12-2006, 11:45 PM
  7. [SOLVED] change column width based on concatenated cells
    By crimsonkng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2005, 06:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1