Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Managing Conditional Formatting Rules in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Data Series in Excel
  • Get column index in Excel Table
  • Everything about Charts in Excel

References

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Last row number in range
  • Basic INDEX MATCH approximate in Excel
  • Lookup entire row in Excel

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation specific characters only
  • Excel Data validation unique values only
  • Excel Data validation number multiple 100
  • Excel Data validation must contain specific text

Sum Largest Numbers using LARGE function in Excel

by

LARGE function example shows you how to create an array formula that sums the largest numbers in a range.

Syntax:
LARGE(array, k)

Returns the k-th largest value in a data set.  You can use LARGE to return the highest, runner-up, or third-place score.

Worked Example:   Excel Functions by Categories

For example,

1. Find the second to largest number, use the following function.

2. To sum the 4 largest numbers (don’t be overwhelmed), add the SUM function and replace 2 with {1,2,3,4}.

3. Finish by pressing CTRL + SHIFT + ENTER.

Worked Example:   How to calculate percent of students absent in Excel

Note: The formula bar indicates that this is an array formula by enclosing it in curly braces {}. Do not type these yourself. They will disappear when you edit the formula.

Explanation: The range (array constant) created by the LARGE function is stored in Excel’s memory, not in a range. The array constant looks as follows.

Worked Example:   Cell References: Relative, Absolute and Mixed Referencing Examples

{22,10,8,6}

This array constant is used as an argument for the SUM function, giving a result of 46.

Post navigation

Previous Post:

How to Create Area Chart in Excel

Next Post:

Excel Line Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to get workdays between dates in Excel
  • Check If Two Dates are same month in Excel
  • Get age from birthday in Excel
  • Get day from date in Excel
  • Basic Overtime Calculation Formula in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel

General

  • How to choose page/paper size in Excel before Printing
  • How to calculate percent sold in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • AutoFit Column Width, AutoFit Row Height in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning