+ Reply to Thread
Results 1 to 3 of 3

AVERAGEIF if an adjacent cell falls within a certain RANGE

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lightbulb AVERAGEIF if an adjacent cell falls within a certain RANGE

    Hi Excel Forum!

    I have a challenge that I hope someone here can solve.

    I am trying to calculate an Average only if an adjacent cell falls within a Range.

    In D16, the Average of the values in E2:E12 is needed, only if the values within B2:B12 falls within the interval expressed in Cell A16, same for A17 until A25.

    I am attaching an spreadsheet to give a clearer picture.

    Thanks in advance!!

    challenge.xlsx

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: AVERAGEIF if an adjacent cell falls within a certain RANGE

    You can use a formula like this in D16

    =IFERROR(AVERAGEIFS(E$2:E$12,B$2:B$12,">=1",B$2:B$12,"<=8"),"")

    copy down the column and then change the 1 and 8 values accordingly.....or if you can put the 1 and the 8 in separate cells you could reference those and the formula would change automatically, e.g. with the lower value in E16 and upper value in F16 try

    =IFERROR(AVERAGEIFS(E$2:E$12,B$2:B$12,">="&E16,B$2:B$12,"<="&F16),"")
    Audere est facere

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: AVERAGEIF if an adjacent cell falls within a certain RANGE

    Wow! That worked incredible! Thanks for solving the question!!
    I (WE) really appreciate it!

+ 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