+ Reply to Thread
Results 1 to 5 of 5

How to Get the TOTAL of BEST OF THREE out of SIX Cell

  1. #1
    Registered User
    Join Date
    08-13-2016
    Location
    NAGPUR
    MS-Off Ver
    MS OFFICE 2007
    Posts
    49

    Post How to Get the TOTAL of BEST OF THREE out of SIX Cell

    AS PER THE BELOW I WANT A FORMULA IN G1 AS THE TOTAL OF BEST OF THREE
    AND ON SERIAL NO. 5 SHOWS THE 4 BEST. THIS ALSO WANT THE TOTAL AS 211.

    Mark1 Mark2 Mark3 Mark4 Mark5 Mark6 Total of Best of Three
    46 51 83 63 81 88
    47 36 38 67 60 65
    50 77 44 65 70 84
    60 84 67 44 60 47
    60 36 45 74 71 61
    41 41 48 57 47 80
    48 39 78 70 83 88
    60 81 40 73 43 69
    37 85 67 78 41 52
    37 88 57 46 56 37
    49 48 58 64 83 85
    70 73 65 51 74 88
    40 39 42 73 68 54
    70 72 73 71 77 83
    87 68 82 43 53 37
    54 70 76 83 84 55
    51 78 77 77 48 69
    36 81 53 78 53 67
    50 67 60 36 68 66
    61 38 63 88 38 52
    79 71 37 40 60 45
    53 41 35 51 37 51

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: How to Get the TOTAL of BEST OF THREE out of SIX Cell

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

    And BTW as we are all friends here, no need for shouting. Thx

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How to Get the TOTAL of BEST OF THREE out of SIX Cell

    Maybe this:

    =SUM(LARGE(A2:F2,{1,2,3}))

    copied down
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    08-13-2016
    Location
    NAGPUR
    MS-Off Ver
    MS OFFICE 2007
    Posts
    49

    Re: How to Get the TOTAL of BEST OF THREE out of SIX Cell

    Thanx a Lot Sir.. Its working..

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How to Get the TOTAL of BEST OF THREE out of SIX Cell

    You're welcome. Thanks for the feedback... next time please supply an Excel file from the START.

+ 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. [SOLVED] If cell in one sheet1 turns green, cell in sheet2 recalculates total
    By petsean007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2019, 02:26 AM
  2. sum total of values in cell based on string match in the same cell
    By BlueSmurf in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-21-2015, 05:13 AM
  3. [SOLVED] Macro to Total a Column Up 15 cells and place total in cell of last row
    By guitarsweety in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2014, 05:25 PM
  4. [SOLVED] need vba help to sum the overall total ,>2 days total & change cell values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-17-2014, 01:55 PM
  5. Need a macro to total different lines and move total to new cell
    By cmefix in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2012, 02:08 PM
  6. [SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"
    By theatricalveggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 12:38 PM
  7. adding numbers in a single cell as a running total in that cell ?
    By jlg371 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 02-01-2009, 08:40 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