+ Reply to Thread
Results 1 to 2 of 2

vlookup for a value appearing more than once

  1. #1
    RITA
    Guest

    vlookup for a value appearing more than once

    In a spreadsheet, I have a value which appears more than once in different
    rows in a table array. I need to do a vlookup which checks the value in this
    table array and sums up the amounts in an adjacent column applicable for this
    value. Can I achieve this?
    --
    rITA
    --
    rITA

  2. #2
    Jason Morin
    Guest

    Re: vlookup for a value appearing more than once

    You need to use SUMIF. For an example, see:

    http://www.techonthenet.com/excel/formulas/sumif.htm

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >In a spreadsheet, I have a value which appears more than

    once in different
    >rows in a table array. I need to do a vlookup which

    checks the value in this
    >table array and sums up the amounts in an adjacent

    column applicable for this
    >value. Can I achieve this?
    >--
    >rITA
    >--
    >rITA
    >.
    >


+ 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