Excel - Large Function with Criteria - array function by Chris Menard

To perform the Large function in Excel with criteria, you have to use an Array Function. An array function is entered by doing CTRL + SHIFT + ENTER on the keyboard.

An array function will have braces around it in the formula bar. { }

***********************
About Chris Menard
Chris provides companies with on-site, hands-on Microsoft Office training. He works mainly in Atlanta, Cobb, Gwinnett, but does training anywhere in the United States.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[amirmoezi]

It's invaluable content to briefly explain large with criteria.. thanks a million.. what about 2 or more criteria?

[aaronbathan]

Thank you! This was very helpful! Never knew that you had to use ctrl shift enter.

[AlexGarcia-oiup]

october sancho 10
october sancho 20
october sancho 30
october sancho 40
october neymar 50

how could i calculate the top 3 scores for sancho in october? i have a data set where 1000 players in october and i need to sum the top three for each player for that month. i tried to do this =IF(AND(E17=C17:C21, F16=B17:B21), SUM(LARGE(D17:D21, {1, 2, 3}))"") but due to the last part of the if function since it says neymar at the bottom it leaves it blank

[ubaidillahmuhammad]

Good job. But please give all the file excel Sir

[aaronbathan]

Thank you! This was very helpful! Never knew that you had to use ctrl shift enter.