Remember Me?

#1
April 29th 10, 12:24 PM
 Junior Member First recorded activity by ExcelBanter: Apr 2010 Posts: 2
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
April 29th 10, 02:01 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jan 2010 Posts: 1,522
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

#3
July 2nd 21, 08:35 AM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Omar Mounier Excel Discussion (Misc queries) 3 February 17th 09 08:39 AM medo Excel Discussion (Misc queries) 2 February 15th 09 12:22 PM Marwa Amin Excel Discussion (Misc queries) 1 December 19th 05 02:24 PM Mark Williams Excel Worksheet Functions 1 July 22nd 05 08:35 PM MXAlher Excel Worksheet Functions 1 November 12th 04 02:33 PM

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