Hello,
I would like to create a function similar to SUMIF(LARGE). Unfortunately large does not work within the sumif function. Can someone advise me how to select the 2 largest values meeting the criteria "A" and add them together? I have been able to come close with a pivot table but ultimately it does not work correctly when "A" has the same value multiple times in the table.
A 1
B 5
C 3
D 4
E 9
A 2
B 3
F 2
G 5
A 1
B 6
Any help is appreciated.
Thanks!
Hello,
How about tie values. in the example if you need answer 3; use this
=SUM(IFERROR(LARGE(IF(A2:A12="A",B2:B12),{1,2}),0))
If answer is 4; use this
=SUM(SUMIFS(B2:B12,A2:A12,"A",B2:B12,IFERROR(LARGE(IF(A2:A12="A",B2:B12),{1,2}),9E300)))
Both are confirmed with CTRL+SHIFT+ENTER
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
The first one worked like a charm. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks