+ Reply to Thread
Results 1 to 2 of 2

vlookup formula assistance

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    Vegas
    MS-Off Ver
    Excel 2010
    Posts
    1

    vlookup formula assistance

    Hello,

    I'm looking for some assistance with a vlookup formula. Here's the scenario, I have data that I am sorting by date - some of the data has multiple values for one date. I would like that data to sum up for the individual date. Here is an example:

    3/31/2013 1 1 SPC 2 200
    3/31/2013 1 2 SPC 4 462
    4/1/2013 1 1 SPC 6 573
    4/1/2013 1 2 SPC 1 110
    4/2/2013 1 1 SPC 17 1920
    4/3/2013 1 1 SPC 17 2051
    4/4/2013 1 1 SPC 12 1395
    4/5/2013 1 1 SPC 8 1062
    4/6/2013 1 1 SPC 9 1238
    4/10/2013 1 1 SPC 1 149
    4/11/2013 1 1 SPC 2 248
    4/12/2013 1 1 SPC 4 446

    The only data I'm interested in are the last two colums. So for 3/31 I would like to see 6 & 662 displayed. Thoughts? Any thoughts on how to put together that formula? I have successfully been able to pull the first number recognized by the date, but not the second.

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: vlookup formula assistance

    Hi jman,

    Look into SUMIF formulas...

    for example: =SUMIF(A1:A15,A25,E1:E15) where A25 is where you put 3/31/2013

    Note the ranges can be changed if needed...
    Last edited by djapigo; 04-03-2013 at 05:01 PM.

+ 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