جمعه نوزدهم دی ۱۳۹۹ - 20:10 - حسين حسين پور -
Sum Largest Numbers
The SUM formula below uses SUM and LARGE to sum the largest numbers in a range. Change {1,2,3,4} to {1,2,3,4,5} to sum the 5 largest numbers.
Note: =LARGE(A1:A11,2) simply returns the second largest number.
با نام و یاد خدا