Help please on rank and sum formulas

[jk51]

Hi,

See table below. For each column, sort the top 5 descending numbers in order and then sum the total. How to do it in excel formula?

Col1 Col2 Col3
23 56 67
25 10 55
53 69 72
68 39 24
32 86 27
11 73 33
44 21 67
81 3 55
54 17 48
22 13 52

Thanks,

Mr Singh

 

[NARAYANK991]

Hi ,

Try this :

=SUM(LARGE(A2:A11, {1,2,3,4,5}))

where your data for one column is in the range A2:A11.

Narayan

 

[jk51]

Thanks Narayan.

Best,

Mr Singh