+ Reply to Thread
Results 1 to 4 of 4

Find the Sum of large 4 numbers from 5 different cell values.

  1. 07-29-2022, 02:13 PM #1
    avijit74
    avijit74 is offline
    Registered User
    Join Date
    12-24-2016
    Location
    Balurghat, West Bengal, India.
    MS-Off Ver
    2019
    Posts
    56

    Find the Sum of large 4 numbers from 5 different cell values.

    Dear all,
    I have marks obtained by Jack in different subjects. I have to take only the Total marks obtained by him for each subject to calculate the sum of best 4 marks. What formula should I use? Please help.
    regards,
    Avijit74
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-29-2022, 02:20 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Find the Sum of large 4 numbers from 5 different cell values.

    Please try

    =SUMPRODUCT(LARGE((D3,G3,J3,M3,P3),{1,2,3,4}))

    or

    =SUMPRODUCT(LARGE(IF(D2:P2="Total",D3:P3),{1,2,3,4}))

    or

    =SUMPRODUCT(AGGREGATE(14,6,D3:P3/(D2:P2="Total"),{1,2,3,4}))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 07-29-2022, 02:33 PM #3
    avijit74
    avijit74 is offline
    Registered User
    Join Date
    12-24-2016
    Location
    Balurghat, West Bengal, India.
    MS-Off Ver
    2019
    Posts
    56

    Re: Find the Sum of large 4 numbers from 5 different cell values.

    Hi Bo_Ry,
    Thank you so much!
    Reply With QuoteRegister To Reply
  4. 07-30-2022, 07:29 AM #4
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Find the Sum of large 4 numbers from 5 different cell values.

    An other way, same result:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find and replace large number of values in large dataset.
    By Brutu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2021, 10:54 AM
  2. [SOLVED] Using LARGE to find cell address with duplicate numbers
    By audax48 in forum Excel General
    Replies: 10
    Last Post: 07-07-2017, 09:42 PM
  3. [SOLVED] find two large numbers!
    By stewart08 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-07-2008, 10:42 AM
  4. Find duplicate numbers in large Excel Spreadsheet
    By Table in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. how to find duplicate cells in large array of numbers
    By DaveB in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  6. Find duplicate numbers in large Excel Spreadsheet
    By Table in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1