Results 1 to 9 of 9

Aggegate formula

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2011
    Location
    Whitefish, Montana
    MS-Off Ver
    Excel 2011 for mac
    Posts
    16

    Aggegate formula

    Aggegate formula not giving sum of lowest 5 cells when there are more than 5 cells that are equal. How do I make G2 equal the lowest 5 cells from column D when all from that team have the same score? G2 should equal 4.5


    help_file.xlsx
    Last edited by mbsmeltzer; 08-31-2015 at 03:19 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04: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