large combine max fuction issue

[vincentwady]

Dear all,

I have an issue about get the largest number(and top 5, top 10) from
the column I have. I used to combine large function and max fuction to
grab the total number back. Here is my old fornula,
=large(A1:A200,1) will give me the largest number
=sum(large(A1:A200,{1,2,3,4,5})) will give me the subtotal of top 5
number
=sum(large(A1:A200,{1,2,3,4,5,6,7,8,9,10})) will return me the
subtotal of top 10 number.

But right now in my column I insert the subtotal in each section I
want to break out. For example,
A
1 100
2 200
3 300
4 =subtotal(9,A1:A3)=600
5 400
6 500
7 600
8 =subtotal(9,A5:A7)=1500
9 =subtotal(9,A1:A8)=2100

So how I can keep the same range but still can get the largest number,
sum of top 5 and top 10 will be my issue. Because it seems no way to
exclude the result of subtotal, but I want the result bring back as:
=large(A1:A9,1)=600
=Sum(large(A1:A9,{1,2,3,4,5}))=2000

Anyone know the alternative solution without select seperate range to
bring the result?

Thanks

 

[Bernard Liengme]

Keep the worksheet tidy; put the subtotals in column B
best wishes