Results 1 to 5 of 5

Thread: VLookUp/Sum

  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question VLookUp/Sum

    Hello

    I'm in need of some assistance. I need to look up the data from Column A in the M2:U243 array (I've shorten the table), once the value is found sum the values in Column U that are an exact match in Column A - returning the value in Column J. Thanks in advance for help.
    Attached Files Attached Files
    Last edited by cocogodiva; 2016-03-28 at 14:33.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Would help if you could post a sample file. Sounds like you're looking for SUMIF or SUMIFS !?

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My apologies, I thought I attached the sample file. Please see above.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Try this in J2 and fill down: =SUMIF(M:M,A2,U:U)

  5. #5
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    YOU ROCK! Thank you!

Posting Permissions

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