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

=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

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!

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:

This will return the sum of the two highest scores in the range.