Hi Experts. I need your advise on how to sum top 5 base on one condition, say
sum top 5 of A. It should be 10+12+7+4+2 = 35. Thanks much!!!
A 1
A 2
C 3
A 4
B 5
A 7
D 9
A 10
A 12
Hi Experts. I need your advise on how to sum top 5 base on one condition, say
sum top 5 of A. It should be 10+12+7+4+2 = 35. Thanks much!!!
A 1
A 2
C 3
A 4
B 5
A 7
D 9
A 10
A 12
Hi!
I'm assuming a lot here, but, try this:
Entered as an array using the key combination of CTRL,SHIFT,ENTER:
=SUM(LARGE(IF(A1:A9="A",B1:B9),{1,2,3,4,5}))
Biff
"luvgreen" <[email protected]> wrote in message
news:[email protected]...
> Hi Experts. I need your advise on how to sum top 5 base on one condition,
> say
> sum top 5 of A. It should be 10+12+7+4+2 = 35. Thanks much!!!
> A 1
> A 2
> C 3
> A 4
> B 5
> A 7
> D 9
> A 10
> A 12
Thank you very much. That's exactly what I need.
"Biff" wrote:
> Hi!
>
> I'm assuming a lot here, but, try this:
>
> Entered as an array using the key combination of CTRL,SHIFT,ENTER:
>
> =SUM(LARGE(IF(A1:A9="A",B1:B9),{1,2,3,4,5}))
>
> Biff
>
> "luvgreen" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Experts. I need your advise on how to sum top 5 base on one condition,
> > say
> > sum top 5 of A. It should be 10+12+7+4+2 = 35. Thanks much!!!
> > A 1
> > A 2
> > C 3
> > A 4
> > B 5
> > A 7
> > D 9
> > A 10
> > A 12
>
>
>
You're welcome. Thanks for the feedback!
Biff
"luvgreen" <[email protected]> wrote in message
news:[email protected]...
> Thank you very much. That's exactly what I need.
>
> "Biff" wrote:
>
>> Hi!
>>
>> I'm assuming a lot here, but, try this:
>>
>> Entered as an array using the key combination of CTRL,SHIFT,ENTER:
>>
>> =SUM(LARGE(IF(A1:A9="A",B1:B9),{1,2,3,4,5}))
>>
>> Biff
>>
>> "luvgreen" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi Experts. I need your advise on how to sum top 5 base on one
>> > condition,
>> > say
>> > sum top 5 of A. It should be 10+12+7+4+2 = 35. Thanks much!!!
>> > A 1
>> > A 2
>> > C 3
>> > A 4
>> > B 5
>> > A 7
>> > D 9
>> > A 10
>> > A 12
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks