Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 29th 10, 12:24 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2010
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  
Old 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
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


  #3   Report Post  
Old July 2nd 21, 08:35 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
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 01:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017