How to sum the top 5 values in excel?
How to sum top 5 in excel?
The question is how to sum the top 5 in Excel, but I create something here that can the top N values.
How to sum top 5 in excel?
The question is how to sum the top 5 in Excel, but I create something here that can the top N values.
Transcript of the video:
How to sum the top five values in Excel.
Let's make it a little bit more flexible.
Put that number five in Excel, we want the equal sum of the large function, will find the largest five.
Comma, and we don't just want the fifth largest, we want the first through fifth largest, so the sequence of five.
Sequence of five is going to generate the numbers one through five.
Close the parenth for sequence, close the parenth for large, close the parenth for sum.
Three parentheses at the end, press enter, and there we go.
9,433.
If we ask for the top three, 6,484.
If we ask for the top one, well that's just one, the 2,935.
Pretty cool little trick there using large. If you like these videos, please, down below, Like, Subscribe and Ring the Bell. Feel free to post any questions or comments in the comments below.
Let's make it a little bit more flexible.
Put that number five in Excel, we want the equal sum of the large function, will find the largest five.
Comma, and we don't just want the fifth largest, we want the first through fifth largest, so the sequence of five.
Sequence of five is going to generate the numbers one through five.
Close the parenth for sequence, close the parenth for large, close the parenth for sum.
Three parentheses at the end, press enter, and there we go.
9,433.
If we ask for the top three, 6,484.
If we ask for the top one, well that's just one, the 2,935.
Pretty cool little trick there using large. If you like these videos, please, down below, Like, Subscribe and Ring the Bell. Feel free to post any questions or comments in the comments below.
