Results 1 to 9 of 9

Counting half or 50% of a fluctuating range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Flemington, New Jersey
    MS-Off Ver
    Excel 2003
    Posts
    10

    Counting half or 50% of a fluctuating range of cells

    So, I'm trying to make a sheet that will calculate handicaps.

    I need no more than 20 cells across per person. But I need the formula to calculate the average of the lowest 50%.

    10 numbers in a range, I need the formula to grab the lowest 5 values then divide them by the cell count.
    Example: Grids.png


    But as numbers are added in the row that may be lower I need it to keep calculating.

    Example: 12 numbers will then take the lowest 6 values and find the average.
    17 numbers, will take the lowest 8 values.

    I think it's going to required 2 pages as a reference. In my mind I have a Find lowest n value in a range, but I need an IF formula to somehow choose how many cells to add together.
    Like if there are 10 cells, add cells 1 to 5... I don't even know it that's possible..

    any help would be great!
    Last edited by AliGW; 11-18-2019 at 09:52 AM. Reason: Irrelevant section of title removed.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Iteratively cut a column in half until the number of cells in each half is less than 10...
    By LineOfBestFit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2015, 12:31 AM
  2. The formula is not adjusting to the fluctuating range automatically
    By geoffrey22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2013, 10:05 AM
  3. [SOLVED] how to add fluctuating cells from different sheets
    By guy1985 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-20-2013, 06:22 PM
  4. Naming a fluctuating range
    By MisterPan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2009, 01:43 PM
  5. Replies: 3
    Last Post: 05-26-2006, 02:45 PM
  6. Replies: 0
    Last Post: 05-26-2006, 02:05 PM
  7. [SOLVED] complex fomula: counting cells that are blank
    By shmurphing in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2005, 06: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