In this article, we will learn how to sum the largest two numbers in a range in Microsoft Excel 2010.
In order to calculate the sum of two largest numbers in any range, we will use a combination of SUM & LARGE functions.
SUM: Adds all the numbers in a range of cells
number1: The first argument that you want to add.
number2: The second argument that you want to add.
There can be maximum 255 arguments. Refer below screenshot:
LARGE: Returns the k-th largest value in a data set. For example, you can use LARGE function to return the highest marks scored in a class.
array: The array or range of cells for which you want to find the k-th largest value.
k: Itis the kth position from the largest value to return in the array or range of cells.
To calculate the sum of two largest numbers, we have to take an example:
Both are yielding the same result i.e. 95.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.