Results 1 to 5 of 5

adding top 6 results... but still adding if there are less then 6 entries

Threaded View

cnak adding top 6 results... but... 05-27-2019, 11:41 PM
kersplash Re: adding top 6 results...... 05-27-2019, 11:44 PM
Phuocam Re: adding top 6 results...... 05-28-2019, 12:55 AM
José Augusto Re: adding top 6 results...... 05-28-2019, 05:30 AM
Bo_Ry Re: adding top 6 results...... 05-28-2019, 05:53 AM
  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    365
    Posts
    63

    adding top 6 results... but still adding if there are less then 6 entries

    I need to add the top 6 results from a series of results but the problem I am having is when there are less then 6 entries it won't add until there are at least 6

    this is the formula I am using =SUM(LARGE(C5:N5,{1,2,3,4,5,6}))

    it works great if I have 6 or more entries but I need it to add the entries if there are less then 6 as well and then if over 6 it needs to add the top 6 value wise
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding New Entries From The Top
    By Jimbob 2705 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-20-2014, 06:10 PM
  2. [SOLVED] Problems with Adding new entries at the end of range
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2013, 09:18 AM
  3. [SOLVED] Help with adding up referenced data entries
    By pete36 in forum Excel General
    Replies: 4
    Last Post: 05-23-2012, 03:11 AM
  4. Replies: 3
    Last Post: 03-15-2011, 12:56 PM
  5. Adding entries to PivotTable via loop
    By bd528 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2010, 08:08 AM
  6. adding 3 entries per month
    By jeremy via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 06:05 PM
  7. Adding Consecutive Entries
    By FLKULCHAR in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 11:48 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