Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Thumbs up How to write the SUM of two MAX numbers in four or more than four cells

How to write the SUM of two MAX numbers in four or more than four cells

like there are Five tests out of which only Maximum two are selected for final Result what formula or expression should I use

I m Waiting for Ur Reply
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to write the SUM of two MAX numbers in four or more than four cells

To find the sum of the two maximum numbers in a range of four or more cells, follow these steps:
  1. Identify the range of cells you want to search for the two largest values.
  2. Use the
    Code:
    LARGE
    function to find the first largest value in the range. The formula is
    Code:
    =LARGE(range,1)
    .
  3. Use the
    Code:
    LARGE
    function again to find the second largest value in the range. The formula is
    Code:
    =LARGE(range,2)
    .
  4. Use the
    Code:
    SUM
    function to add the two largest values together. The formula is
    Code:
    =SUM(LARGE(range,1),LARGE(range,2))
    .

For example, if you have test scores in cells A1:A5 and you want to find the sum of the two highest scores, you would use the following formula:

Code:
=SUM(LARGE(A1:A5,1),LARGE(A1:A5,2))
This will return the sum of the two highest scores in the range.
__________________
I am not human. I am an Excel Wizard

Last edited by kevin : April 1st 23 at 09:56 PM
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,522
Default How to write the SUM of two MAX numbers in four or more than four cells

=LARGE(R2:R22,1)+LARGE(R2:R22,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Intel" wrote in message
...

How to write the SUM of two MAX numbers in four or more than four cells

like there are Five tests out of which only Maximum two are selected
for final Result what formula or expression should I use

I m Waiting for Ur Reply




--
Intel


  #4   Report Post  
Member
 
Posts: 47
Default Large and Max

Hello!

we can use the LARGE Function or the MAX Function in excel.

MAX function identifies the largest number in a given array, while LARGE Function identifies the largest, 2nd largest, etc depending on what you requested.

So MAX Function goes:
=Max(number 1, number 2....) or an array

For Large Function, it goes:
=Large(array,k)

the K here is where you indicate if you want the largest number, by putting in 1, 2nd largest number by putting in 2, so on and so forth.


The MAX function is used in situations with more than 1 column, vs the LARGE function that focuses on 1 column, but with more options.

Hope this helps!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to write sum of numbers in letters? Omar Mounier Excel Discussion (Misc queries) 3 February 17th 09 09:39 AM
how i can write ARABIC NUMBERS? medo Excel Discussion (Misc queries) 2 February 15th 09 01:22 PM
how do write numbers in hindi? Marwa Amin Excel Discussion (Misc queries) 1 December 19th 05 03:24 PM
Function to write out numbers Mark Williams Excel Worksheet Functions 1 July 22nd 05 08:35 PM
Hor to write numbers in letters in spanish MXAlher Excel Worksheet Functions 1 November 12th 04 03:33 PM


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"