+ Reply to Thread
Results 1 to 3 of 3

Extracting cells from one array based on cells in another array

  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Extracting cells from one array based on cells in another array

    Hi and thanks in advance,

    I have two arrays in a spreadsheet. I'll give an eg below ...

    Please Login or Register  to view this content.
    How do I find the sum of all values in array two that correspond to a particular value in array one?
    For eg...
    - the number "2" in array one is in cells Aiii and Bii,
    - cells Aiii and Bii from array one correspond to cells Aix and Bviii in array two
    - therefore, the sum of cells corresponding to the number two is 10 ( from 4 + 6 = 10)

    The result i want will show the following ...

    Please Login or Register  to view this content.
    Cheers.

    Josh

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Extracting cells from one array based on cells in another array

    If we assume for sake of demo your table is A1:B9 (rows 4:6 empty) and criteria are listed in D1:D3 with results to go in E1:E3

    E1: =SUMIF($A$1:$B$3,$D1,$A$7:$B$9)
    copied down to E3

  3. #3
    Registered User
    Join Date
    06-02-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Extracting cells from one array based on cells in another array

    Jeez, that was a bit easy! Thanks Donkey!! Now i'll try applying that to an array a wee bit bigger.

    Thanks again,

    Josh

+ 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