+ Reply to Thread
Results 1 to 2 of 2

using average with match/index?

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Bend, Oregon
    MS-Off Ver
    365 ProPlus
    Posts
    51

    using average with match/index?

    I'm trying to figure out how to index a range, compare two columns and then average another column for all results found.

    A sample is attached with a manual method to show what the result would be, and then a column where the formula would be placed... any help would be fantastic.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-13-2021
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    513

    Re: using average with match/index?

    Enter the following into E2 and copy down:

    =SUMIF($C$2:$C$51, C2, $A$2:$A$51) / COUNTIF($C$2:$C$51, C2)

    That matches all of column D except D40:D42. I think you have an error in those cells: =(3+4+4+7)/4 should be =(3+4+7)/4.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using index and match to find average
    By Stevie G52 in forum Excel General
    Replies: 0
    Last Post: 03-23-2016, 06:22 AM
  2. average & sum using index & match formulas
    By jscalem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2015, 02:51 PM
  3. average with index match
    By jscalem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2015, 02:26 PM
  4. average index match
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2014, 11:21 AM
  5. [SOLVED] Index, Match, Month before calculating AVERAGE
    By overbomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2013, 10:43 AM
  6. Index/Match to find Starting Point of Average, Ending Point of Average Variable
    By tgentry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 01:04 AM
  7. Trying to take an average using INDEX and/or MATCH
    By doraen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2011, 01:46 PM

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