+ Reply to Thread
Results 1 to 4 of 4

Averages of VLOOKUP Items

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    Arizona, U.S.
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question Averages of VLOOKUP Items

    Good Morning. I am in need of a way to VLOOKUP multiples of the same name, and then get the average of the times. Capture.PNG
    For example if I Look up all sizes "M", I would like their average time in a cell to the right? Can someone please help? Thanks You.

  2. #2
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: Averages of VLOOKUP Items

    Hi, you can use AVERAGEIF function for the same
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    /Rgds,
    Ganesh Pitale

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Averages of VLOOKUP Items

    Try

    =AverageIF(A:A,"M",B:B)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    06-21-2013
    Location
    Arizona, U.S.
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Averages of VLOOKUP Items

    Thank You guys, it's working perfect.

+ 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