+ Reply to Thread
Results 1 to 5 of 5

AVERAGEIFS formula with average range depending on cell

  1. #1
    Registered User
    Join Date
    03-05-2018
    Location
    GENEVA, SWITZERLAND
    MS-Off Ver
    10
    Posts
    10

    AVERAGEIFS formula with average range depending on cell

    Hello guys!

    I am a little bit lost and I even don't know if this is the correct forum to post my question. I am currently trying to use the AVERAGEIFs formula, but i would like the average_range to depend on a cell.

    I have a worksheet called data where i have several columns with ranges... for example.... r_apples, r_oranges...

    depending on what i want to average... i would like to write in the cell B5 for example: r_apples...

    so in the formula =AVERAGIFS(B5,....other criteria). Is this possible? I haven't seen this question before and I have searched in all internet. Do you have any suggestion? I am pretty desperate!

    Thank you in advance,

    Laura
    Last edited by laura.gomper; 08-20-2020 at 06:08 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,361

    Re: AVERAGEIFS formula with average range depending on cell

    Welcome!
    INDIRECT may helps, but I just guess, because there is no sample worksheet.
    Could you pls send a sample worksheet?
    Follow instruction on top of the page (in yellow banner)

  3. #3
    Registered User
    Join Date
    03-05-2018
    Location
    GENEVA, SWITZERLAND
    MS-Off Ver
    10
    Posts
    10

    Re: AVERAGEIFS formula with average range depending on cell

    OMG... i have been looking for this during a while now and now it is solved so easily. Shame on me. Thank you so so so so much...

    Laura.

  4. #4
    Registered User
    Join Date
    03-05-2018
    Location
    GENEVA, SWITZERLAND
    MS-Off Ver
    10
    Posts
    10

    Re: AVERAGEIFS formula with average range depending on cell

    Where do i put this thread as solved? Not able to see it!

  5. #5
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: AVERAGEIFS formula with average range depending on cell

    Or maybe

    =AVERAGE(INDEX(B3:C6,0,MATCH(F3,$B$2:$C$2,0)))
    where B3:C6 is data to average, B2:C2 are r_apples, r_oranges and F3 has the name of one that columns.

    See the file
    Attached Files Attached Files

+ 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. [SOLVED] Averageifs formula used on more than 1 column to average
    By paolina13 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-08-2018, 05:55 PM
  2. [SOLVED] Different results for =average & averageifs for same data range
    By ljbrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2017, 05:49 PM
  3. [SOLVED] AVERAGEIFS to average times in a range if criteria met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2016, 03:06 AM
  4. AVERAGEIFS Formula With A Range
    By tank0r in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2014, 01:33 PM
  5. [SOLVED] Formula to select a named range depending on value in one cell
    By Excelfail in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-02-2014, 08:51 PM
  6. [SOLVED] How to get an AVERAGEIFS formula to not include cell in average, by triggering switch?
    By Carmstrong227 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2013, 01:15 PM
  7. Replies: 8
    Last Post: 05-19-2005, 07:06 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