+ Reply to Thread
Results 1 to 2 of 2

formulea for adding top 4 numbers out of row of six

  1. #1
    Registered User
    Join Date
    01-17-2015
    Location
    redditch uk
    MS-Off Ver
    mac 2011
    Posts
    4

    formulea for adding top 4 numbers out of row of six

    I have the following formula for adding only the highest four numbers out of a row of six,=SUM(MAX(LARGE(B8:G8,1),0),MAX(LARGE(B8:G8,2),0),MAX(LARGE(B8:G8,3),0), MAX(LARGE(B8:G8,4),0)) but when only 3 numbers are filled in does not work unless a zero is inserted in at least one other cell in group, I thought that the ),0)) would show empty cell as zero, any suggestions would be most welcom

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: formulea for adding top 4 numbers out of row of six

    Erm, somehow this works regardless of how many cells are blank

    =SUM((LARGE(A1:F1,ROW(1:4))))
    Array formula, use Ctrl-Shift-Enter

    I was looking at:
    http://www.cpearson.com/excel/arrayformulas.aspx

    About halfway down

    Creating Sequences And Loops For Array Formulas
    Last edited by Special-K; 02-03-2015 at 08:41 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. filter list of text for unique entries using formulea
    By Domenic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  2. filter list of text for unique entries using formulea
    By Domenic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. filter list of text for unique entries using formulea
    By The Nephalim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. filter list of text for unique entries using formulea
    By The Nephalim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. [SOLVED] filter list of text for unique entries using formulea
    By The Nephalim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2005, 08:05 AM

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