Yesterday i need to find the SUM of 3 largest value in a range using EXCEL.
This is how to find the SUM of 3 largest value from 7 value in a range of 7 number.
= SUM(LARGE (A1:A7, {1,2,3}))
SUM is used for summation
LARGE is used to find largest number
Let say with this number from A1:A7
1,2,3,4,5,6,7
using = LARGE (A1:A7, {1,2,3}) alone will result
7 (current cell ) 6 (next cell) 5(next 2 cell)
Using = SUM(LARGE (A1:A7, {1,2,3})) will result in 7+6+5 = 18 in current cell
No comments:
Post a Comment