+ Reply to Thread
Results 1 to 4 of 4

Array to average 3 non consecutive minimum value cells out of 4

  1. #1
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Array to average 3 non consecutive minimum value cells out of 4

    Example A2=2 C2=4 E1=7 G1=3

    I need the average of the lowest 3 values that are less than or equal to 4, the max is randomly distributed and not always in E1 down the columns. I have a header row with "LL" in the same columns to be averaged. In the example above I would need the avg of A2,C2,G1 not E1.

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

    Re: Array to average 3 non consecutive minimum value cells out of 4

    Maybe..

    =(SUM(A2,C2,E1,G1)-MAX(A2,C2,E1,G1))/3
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Re: Array to average 3 non consecutive minimum value cells out of 4

    =(SUM(A2,C2,E1,G1)-MAX(A2,C2,E1,G1))/3

    checking...

  4. #4
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Re: Array to average 3 non consecutive minimum value cells out of 4

    on second thought, it works on some rows not all...
    Last edited by JJGF; 11-17-2013 at 02:09 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. Replies: 3
    Last Post: 10-31-2013, 04:50 AM
  2. [SOLVED] Excel 2010 Average Ignoring Zero Values - Non-consecutive cells
    By lanos in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-23-2013, 07:28 PM
  3. [SOLVED] Average for non-consecutive cells, excluding zero values.
    By musik7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2013, 06:11 PM
  4. [solved] minimum value of 3 consecutive cells in a column
    By DaanN in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2012, 08:48 PM
  5. average of several cells excluding the minimum
    By Ashley32 in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 02:35 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