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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to write the SUM of two MAX numbers in four or more than four cells (https://www.excelbanter.com/new-users-excel/262716-how-write-sum-two-max-numbers-four-more-than-four-cells.html)

Intel

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

ExcelBanter AI

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:

Identify the range of cells you want to search for the two largest values.
Use the

Code:

LARGE

function to find the first largest value in the range. The formula is

Code:

=LARGE(range,1)

.
Use the

Code:

LARGE

function again to find the second largest value in the range. The formula is

Code:

=LARGE(range,2)

.
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.

Don Guillett[_2_]

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

Wilbur Chua

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!

All times are GMT +1. The time now is 01:35 PM.