+ Reply to Thread
Results 1 to 3 of 3

Sort through a column and for every X, add values from next column

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Sort through a column and for every X, add values from next column

    I wasn't quite sure how to title this, but here is the situation:

    I am looking to get D7 on the 'WS' worksheet to look through both column B and C of the 'AJE' worksheet and find anywhere there is the label of the value of A7(from WS!), and then sum the values of column D - column E on AJE! for only those corresponding rows

    I then want to carry this down for each cell of column D & E on 'WS'

    I'm not sure if this is something I can do with functions, or not. I do know a little VBA (if I have to go that route) but haven't done much within excel: so even how to get started would be great.

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Sort through a column and for every X, add values from next column

    See attached?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-15-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sort through a column and for every X, add values from next column

    Thanks a million BB. That got me started & attached is what I ended up with, if you care to see the final result.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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