+ Reply to Thread
Results 1 to 1 of 1

Using index and match to find average

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    Ireland
    MS-Off Ver
    13
    Posts
    2

    Using index and match to find average

    Hi I'm wondering if someone cud help me. I am trying to use index and match to find the average of a number of columns of cells and output the answer in another table. Been at it for ages but can't seem to get it to work. Any help wud be greatly appreciated. Thanks

    This is the latest formula ive been tryin to sort out
    =AVERAGE(INDEX(B2:G9,),MATCH(I8,B1:G1,0),INDEX(C2:C9,),MATCH(I8,B1:G1,0)INDEX(D2:D9,),MATCH(I8,B1:G1,0)INDEX(E2:E9,),MATCH(I8,B1:G1,0),INDEX(F2:F9,),
    Last edited by Stevie G52; 03-23-2016 at 06:27 AM.

+ 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. average with index match
    By jscalem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2015, 02:26 PM
  2. average index match
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2014, 11:21 AM
  3. [SOLVED] Find AVERAGE of another column of unsorted list (using INDEX/MATCH ?)
    By seaottr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2013, 10:24 PM
  4. 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
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  6. Index/Match formula to find average.
    By whitehead6682 in forum Excel General
    Replies: 11
    Last Post: 11-17-2011, 03:02 PM
  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