Results 1 to 5 of 5

Summing in a VLOOKUP function

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2008
    Location
    Perth
    Posts
    11

    Summing in a VLOOKUP function

    I have a vlookup function that is looking up a range of cells.

    I would like it to look in the range and then sum up all of the values that meet the criteria.

    At the moment it will only bring back the value of the first match it finds in the range, I would like it to bring back the sum of all the values it finds in the range, is this possible?

    Example

    Vlookup(Jan-08,$a3:$c$7,column 4 values, 0), if Jan-08 is listed in the range more than once, I would like it to add up all the values in column 4 that match.

    Thanks

    Lesa
    Last edited by Lesa Muir; 12-17-2008 at 10:29 PM.

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