Hi,
Very much a beginner / intermediary so apologies if this is simple or been asked a thousand times.
I would like to pull through the largest value in a range with multiple criteria. I'd like to do the same for the top 3 and then the top 10 values.
Currently cannot seem to stumble upon a way to do this for multiple criteria - is it only possible to do when assuming one criteria?
Any help would be much appreciated!
Thanks!
McNutt
It depends on which of those exactly you're trying for, and what format you need the output in, but I'm pretty sure you can accomplish what you want with SUMIFS, or a MAX(IF) or LARGE(IF) type of array construction.
Can you post an example spreadsheet with the exact criteria, with some example data in the correct format?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Hi, I have included an attachment. so I would want,
A) The largest secondaries fund (value) closed in 2017.
B) The sum of the largest 3 secondaries funds closed in 2017
Thanks again
Last edited by SamMcNutt; 02-21-2018 at 04:02 AM.
Hi
Use this for A)
Formula:
Please Login or Register to view this content.
Use this for B)
Formula:Please Login or Register to view this content.
for A
=SUMPRODUCT(LARGE((B2:B24=2017)*(C2:C24="Secondaries")*(A2:A24),{1}))
for B
=SUMPRODUCT(LARGE((B2:B24=2017)*(C2:C24="Secondaries")*(A2:A24),{1,2,3}))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Brilliant - both work perfectly.
Thanks everybody, have a great day/evening.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks